Error Accessing File. Network Connection may be lost.

1

10SNUT

I get the subject error when attempting to create, delete, and modify VBA
code. I also cannot create a VBA procedure because of the error:
Microsoft Access failed to create the Visual Basic module '|,'

I don't know what either of the errorss means. I have created modules from
scratch, and I don't get these errors. These errors occur on .mdb
applications that were created previously.

Any suggestions??
10SNUT
 
D

Dirk Goldgar

10SNUT said:
I get the subject error when attempting to create, delete, and modify
VBA code. I also cannot create a VBA procedure because of the error:
Microsoft Access failed to create the Visual Basic module '|,'

I don't know what either of the errorss means. I have created
modules from scratch, and I don't get these errors. These errors
occur on .mdb applications that were created previously.

Any suggestions??

This error represents a particular kind of corruption in your VB
project. Are you using Access 2000, but not patched with SP3? If so,
see this KB article describing the nasty bug that may have bitten you:

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

If that article does match your circumstances, then Office 2000 SP3
fixes the bug, but that won't repair your corrupted database. You'll
have to resort to a backup, or else try importing all objects to a new
database -- some objects probably won't import, and you'll have to
recreate them from scratch. When you do import the objects, unless
you've applied the service pack, it is *crucial* that you compile and
save the project before closing the database.

If that article does not apply to you, your corruption probably has
another cause, but you may still have to take the same steps to recover
from it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top