Forms Mostly Disappearing - BCP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top