Error received

[Sheila Lisenby]

Hi All I am hoping that someone out there can help me.

I am currently using Access 2000.
The data is in an access database, the program is in
another access database with the tables linked to the
first. They are both sitting in the same folder on my pc.

The program has forms, reports, modules (visual basic),
etc....

I have been updated some of the forms and reports
specified by the client. The other day all of a sudden I
started receiving the following error...
'Error Accessing File. Network connection may have
been lost'
This error was expanded saying something about the
[event procedure] and the ONLOAD. I have check all
the properties and compared them with an old version
before changes were made and they are exactly the same.

I have done the following to try and correct this but I
can not get rid of the message.
1. Repair database
2. Remove table links and relink
3. Just relink tables
4. Remove last code (visual basic) that I was working on.
5. Compare properties of forms

I would appreciate any help available.

Thank you
Sheila

 

[Luke Bellamy]

Hi Sheila,
I have had this many times myself. The database mdb file is
corrupted unfortunately. There is alot of good information here:
http://www.granite.ab.ca/access/corruptmdbs.htm

Heres the microsoft KB article about this particular problem:
http://support.microsoft.com/?kbid=304548

Probably the best thing you can do is continually backup your work
as when it happens to me I have a fresh backup waiting for me
that saves lots of time. I especially do this when I am importing objects
or copying objects such as reports/forms as a basis for a new one.

This is what has worked for me in this situation:
1. Create a shortcut to your mdb database file
2. Add the swicth /decompile to it. So the shortcut would have
something like this in it "C:\Program Files\Microsoft
Office\Office\msaccess.exe" "C:\myDBFile.mdb" /decompile.
3. Open the file with this shortcut HOLDING the shift key down to by pass
any startup
processing.
4. If there are any errors during startup note the object names that made
the error
(i.e it will be a report/form or other object name failing to load).
5. Delete any of these objects. I find they are usually the last object I
imported/created
so not too much work to re-create/import it.
6. Close Access and repeat step 3 until it loads without any errors.
7. Once it has loaded OK open a code module and compile the project.
8. Close Access and run a repair and compact.

HTH