Access 2003/ADP database corruption

[alderran]

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.


That's just one of many examples. It happens all the time. If I use Access
2007 it happens less often, but still it's a pretty unstable file. I have
100's maybe even 1000's of hours devoted to it and I'm always afraid to do
anything without a million copies. Now my client is asking about making his
own changes to the forms. Which would normally be okay but not with this
file.

any help would be greatly appreciated!

 

[bcap]

Yep, ADP files corrupt easily and frequently.

Usually importing everything into a new file cures it, but not always!
Ensure that you make very frequent backup copies!

 

[Sylvain Lafontaine]

And especially if you are opening your ADP project file over a bad network.

If copying or importing the objects don't work, then you should rebuild your
forms: create an empty form and then copy&paste all the controls from the
other form; after that, copy the code. To simplifying the copy of the
controls at their exact same location, add a control at the position (0,0)
before doing the copy&paste.

Also, you can change the default font/size: create a form called Normal and
then click on any control *in the toolbar*, for example the Label control.
In the property form, you should see Default Label. Change its properties
and close the Normal form. Now, all new forms will be created with the new
defaults. You can also change the default values of an existing form but
this must be done form by form. Same thing for the reports.

 

[a a r o n _ k e m p f]

I really don't think that I've had any problems with this since Access
2000.

Honestly. Not one crash or corruption.

-Aaron

 

[alderran]

Funny thing is just yesterday I had an Access 2007 .accdb format file
crashing on me. I have a form with a subform. If I go in and set the link
master and link child properties and then hit save it crashes. I tried
copying all the objects into a new file and it still crashes.

Working with .adp files it crashes all the time too. For a while I thought
it was because I had Office 2003 and 2007 on the same pc, but recently my
hard drive died and I only installed Office 2007, yet it still crashes.

 

[bcap]

The fact that Aaron has never had a crash or corruption simply proves that
he doesn't do any real work.