Error accessing file message-Need major help!!!

[Jussca]

I have created a transportation database that performs multiple functions
i.e. Applications, invoicing, requests, emailing requests etc.. When I opened
the database this morning my switchboard appeared. When I clicked on the
command button to open my invoices I was greeted with an "Error accessing
files. Network connection may be lost" It does not appear on all 17 command
buttons on my switchboard just a select few. I have already tried some of
the suggestions in the forum such as creating a blank database and importing
the files. I had the same outcome as another person where it worked the first
time I tried to use it then it went back to the same problem again. This is
a rather large database 83.7MB and I'm not looking forward to having to redo
it so I'm hoping someone out there might have some suggestions. I am not an
expert but I have managed to create this database that was functioning very
well. I created it all by design as I am not familiar with the code aspect of
Access. PLEASE HELP!!!

 

[Dirk Goldgar]

I have created a transportation database that performs multiple
functions i.e. Applications, invoicing, requests, emailing requests
etc.. When I opened the database this morning my switchboard
appeared. When I clicked on the command button to open my invoices I
was greeted with an "Error accessing files. Network connection may be
lost" It does not appear on all 17 command buttons on my switchboard
just a select few. I have already tried some of the suggestions in
the forum such as creating a blank database and importing the files.
I had the same outcome as another person where it worked the first
time I tried to use it then it went back to the same problem again.
This is a rather large database 83.7MB and I'm not looking forward to
having to redo it so I'm hoping someone out there might have some
suggestions. I am not an expert but I have managed to create this
database that was functioning very well. I created it all by design
as I am not familiar with the code aspect of Access. PLEASE HELP!!!

That particular error is the hallmark of a kind of VBA corruption that
is most commonly caused by importing code modules (including forms or
reports that have code modules behind them) under a specific set of
conditions. Have you read KB article 304548:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

Does it seem as though it may apply in your case? If so, you need to
install Office 2000 SP3 to fix the bug that causes the corruption, *and
also* you need to repair your corrupted database. This normally done by
importing all objects to a new database. You say you've done that, but
did you first install the SP3 service pack? If not, then after
importing the objects, it is *crucial* that you compile and save the
project (in VB Editor, click Debug -> Compile) before closing the
database. Did you do that?

If you did, and you still get the error, then you may try decompiling
your database. Here's how:

1. With the database closed -- no users in it at all -- and (ideally)
Access not running, make a backup copy.

2. On the task bar, click Start -> Run...

3. Enter this (adapted to match your database path and name) in the Run
dialog box and click OK:

msaccess.exe /decompile "C:\My Documents\YourDBName.mdb"

You may need to include the full path to msaccess.exe, but I don't find
that to be the case when I try it. Depending on your Access version,
you may not get any sign that anything in particular happened. Your
database will probably open in Access.

4. Compact and Repair your database.

5. Open the database again, press Alt+F11 to switch to the VB Editor,
and click Debug -> Compile (your project). If any errors appear, fix
them and recompile.

6. Close the VB Editor. Compact & Repair again.

See if the problem has disappeared.