Error Accessing File. HELP!!

[Richard Albrecht]

Hi,

Using Access 2000 and all of a sudden on of my apps won't run. No mater
what form I click on I get the error "Error accessing file. Network
connection may have been lost."

I have no Idea what file and there is no problem with the network. I'm also
using Visual Source Safe with this appklication. I have other apps that run
fine???

I just love the way Access doesn't tell you which file!

Rich

 

[Tom Ross]

There is no network problem here.

This is a corrupted database, ususlly caused by a form containing VB code or
a module. Most of your database is probably OK. But you have significatn
headaches to deal with to fix this and keep it from coming back.

You whould rebuild your database. Your tables should be intact and
unaffected
\
1. Open a new database and import the tables and queries from the old
database.

2 Import those forms and reports that are not corrupted (sometimes you
have to use trial and error ) to find out which one is causing the trouble.
a after importing each set of form or report. Open a form indesign
view. Go to the VBasic screen and compile the database. If the error crops
up on compile then one of the last edited forms is the problem.

3. When you get the intact items imported you must import the corrupted
form.
In the original database cut all of the VB code and paste into a
text file for later retrieveal
Set the 'Has Module' property of the form to no. and save the form

go to the new database import the form, past the VBcode back in and
COMPILE IMMEDIATELTY

If it is a corrupted module, copy the code from the old module to
the clipboard. Open the new database, create a new module and paste the
code. COMPILE IMMEDIATELTY

In the future. Get the service packs for Access 2000 and intall them.
Whenever you import, or copy and past any form with code or any code,
COMPILE IMMEDIATELTY. Do not test befor compiling.

On you network, do not use hubs to connect Access users. Use switches!

 

[Tom Ross]

This link has a lot of explanation and help
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304548

 

[Richard Albrecht]

Thank you very much for the incredible detail.

Rich

 

[Tom Ross]

I spent too much time with this problem before I came here to ask. Wouldn't
want anyone else to go through that much stress.
Tom