Program failure

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

Guest

A database which has been running successfully for some time has started
reporting an error when any VBA calls are made. The database reports the
following error:

Error accessing file. Network connections may have been lost.

This must be due to some sort of corruption as the computer is not part of a
network. Any suggestions as to why this should happen would be appreciated
 
Hi Allen
Thanks for your response. I have followed the sites instructions and
completed all the required tasks. But when I open the imported forms and try
to move the code from the saved module back to the form I am unable to create
a module.
Regards

JoeBo
 
Did you apply Service Pack 3 for Office 2000 yet?
(You will need to apply at least Service Pack 1a first.)

After that, make sure you also get Service Pack 8 for JET 4. It is also
available under Downloads at support.microsoft.com.

Once you have done that, the problem will not recur. You should then be able
to rebuild your database (although some of the stuff may not import). Steps:

1. Create a new (blank) database.

2. Turn off the Name AutoCorrect check boxes under:
Tools | Options | General.
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

3. Import (File | Get External | Import) the tables, or link them (File |
Get External | Link) if the database is split.

4. Import the other objects (queries, forms, reports, macros, modules.)

5. Set minimal References under Tools | References (from the code window).

6. Compile (Debug menu, from the code window).

At this point, you should have a stable database that will not corrupt like
that again.
 
Hi Allen

Many Thanks for your solutions to my problem. I found that the only way I
was able to work around the forms problem was to create a new form and copy
across the controls from the original forms select a new trigger event to
start a forms module and then copy my saved forms module into the new form
delete the original and compile and save the new form with the originals
name, phew!!! The time it took me to do this for all the forms could all have
been saved had I had abetter back up routine as this database was being
developed? The database is now fully functional. Hard lesson learned,
committed to a more regular back up routine and once again in your debt.

Regards
JoeBo
 
Back
Top