Access 2003 Corrupting adp files

[Access]

Anyone else experiencing corruption problems using Access 2003 to
edit .adp files? I've been experiencing corruption problems with a
particular database. I've tried copying all the objects into a new
file, but it didn't help.

Here is an example of the problem, yesterday I added a new field to my
SQL table. To put it on the form I copied an existing text field and
converted that field from text to combo box. Quicker because I'm
using a different font/size than the Access default. Anyway each time
I did that Access would crash when I would try to save the form. When
Access would reopen the form was unusable. I couldn't even open it.
I tried it a second time just to see if it was a series of actions
that would consistently crash Access and it did crash again.

I went to a back up copy and created a new combo box field from the
toolbox and it saves fine.

[lyle fairfield]

Just this morning this happened repeatedly to me when I copied a
textbox from a group header on a report to another group footer and
changed it to a label. Solution was the same as well; I stopped
copying the textbox and just created a new label; no more crash.
(Access 2007 - 2000 ADP - Vista).

On Jul 26, 9:26*am, Access <alderran...@gm ail.comwrote:

Anyone else experiencing corruption problems using Access 2003 to
edit .adp files? *I've been experiencing corruption problems with a
particular database. *I've tried copying all the objects into a new
file, but it didn't help.

Here is an example of the problem, yesterday I added a new field to my
SQL table. *To put it on the form I copied an existing text field and
converted that field from text to combo box. *Quicker because I'm
using a different font/size than the Access default. *Anyway each time
I did that Access would crash when I would try to save the form. *When
Access would reopen the form was unusable. *I couldn't even open it.
I tried it a second time just to see if it was a series of actions
that would consistently crash Access and it did crash again.

I went to a back up copy and created a new combo box field from the
toolbox and it saves fine.

[bcap]

Yep, just about the first thing I discovered with Access 2007 is that if you
change a text box to a label and then save the form, Access will crash every
time. It's on Allen Browne's list of bugs, and is *not* fixed in SP1.

However, the OP is using Access 2003, where I for one have not encountered
this particular problem. However, in my experience Access 2003 ADP files
*are* generally very corruption-prone.

"lyle fairfield" <ly************ @gmail.comwrote in message
news:4c******** *************** ***********@34g 2000hsh.googleg roups.com...
Just this morning this happened repeatedly to me when I copied a
textbox from a group header on a report to another group footer and
changed it to a label. Solution was the same as well; I stopped
copying the textbox and just created a new label; no more crash.
(Access 2007 - 2000 ADP - Vista).

On Jul 26, 9:26 am, Access <alderran...@gm ail.comwrote:

Anyone else experiencing corruption problems using Access 2003 to
edit .adp files? I've been experiencing corruption problems with a
particular database. I've tried copying all the objects into a new
file, but it didn't help.

Here is an example of the problem, yesterday I added a new field to my
SQL table. To put it on the form I copied an existing text field and
converted that field from text to combo box. Quicker because I'm
using a different font/size than the Access default. Anyway each time
I did that Access would crash when I would try to save the form. When
Access would reopen the form was unusable. I couldn't even open it.
I tried it a second time just to see if it was a series of actions
that would consistently crash Access and it did crash again.

I went to a back up copy and created a new combo box field from the
toolbox and it saves fine.