Forms Mostly Disappearing - BCP

B

BCP

I have an Acess 2000 database that has a nightly batch process that does a
trasnfer test function. Fairly frequently when I come in in the mourning and
I click one of my forms to open it I get the message Form Name misspelled.
This is very strange since I can see the form in the form tab and the form is
still in the MSObjects table. The rest of my forms give an message like 18
errors encountered when I try to open them.
 
O

Ofer

I have a simillar paoblem with my mdb, usually the size of it 30MB, after the
barch run through the night, it get to 200MB, and then it start giving me all
kind of errors.

So every morning a copy a new mdb to my local pc.
Check what happen to your mdb, does it grow, or if the application is closed
not in the right order (computer is shut down without closing the
application) it can cause a curroption in the mdb, and it need compact and
repair.
So the best thing will be, to copy a new mdb to the computer every day.
 
Top