Error Accessing File. Network Connection may be lost.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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??
Click to expand...

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.
 
Back
Top