Access 2000 after installing Office 2003

[Liz Crites]

I was building a 2000 database and installed Office
2003. The 2000 database worked for a day or two and then
started giving me the Microsoft Visual Basic
message "Error accessing file. Network connection may
have been lost." anytime I try to run a macro or visual
basic code. I've tried importing all the tables, forms,
etc. into a new database and it still does it. I've also
tried compacting/repairing the database.

Any ideas?

Thanks!

Liz

 

[GVaught]

This is an old standing problem in Access 2000 database. There is a long
solution that you can find under the Microsoft Knowledge base, but the
easiest solution I've found is:

You can try this on your current database, but you most likely will still
get the error.

Create a new database
After importing any forms, reports, modules, macros into a new database
immediately issue a compile against the database. This ensures that anything
imported gets correctly 'referenced' to the database. Do not close down the
database until you have issued the compile and get a successful compile. I
would issue the compile after each section import. Example: Import Forms,
compile; Import reports, compile etc.

In rare instances you still may get the Network Error, in this case you may
need to follow the Knowledge base.

 

[Steven Parsons [MSFT]]

Hi Liz -

This is Steven from Microsoft Access Technical Support replying to your
newsgroup post.

The Knowledgebase documents that discuss this issue are as follows:

You receive an error message when you try to view the code in a module,
compile a database, create an MDE file or execute code in Access 2000
http://support.microsoft.com/default.aspx?scid=KB;EN-US;304548

Issues fixed in Access 2000 by Office 2000 Service Pack 3
http://support.microsoft.com/default.aspx?scid=KB;EN-US;326605

Please let me know if this solves your problem or if you would like further
assistance. I look forward to hearing from you.

Sincerely,
Steven Parsons [MSFT]
Microsoft Access Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! (http://www.microsoft.com/security)