Error Accessing File when trying to access the VB Code

[Guest]

Hi! i'm encountering a rather strange but annoying problem. i have an Access
dbase with linked tables, & created forms to run some reports.

all works fine, but once in a while, when i try to access the VB Code I get
an error 'Error accessing file. Network connection may have been lost'.
i checked the network and could access the network drive where the access
dbase is stored.

Since i had a backup of the access dbase in the same network folder, i tried
it out. i can access the same code but without any problems.

so, each time i'm getting this error, i revert back to the last backup & use
that.

any ideas what could be causing this annoying problem?

regards,

Dave

 

[Allan Murphy]

Try this link http://support.microsoft.com/?kbid=304548

I had the same problem when I was developing a database on our network, for
some reason the form, report or code that I was working on would corrupt
with no warning etc. Like you when I ran the database I got the error
message. I believe that due to the network traffic my connection developed a
hiccup and terminated the connection.

I created a blank database and imported a few items at a time from the old
database until the error message was displayed then I knew that the last
item imported was corrupt.

 

[Guest]

You have corruption in your database. This site will explain it and show
you how to fix it.

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

 

[Guest]

thanks for the help....at least it's a know problem & once i update to the
latest service pack all will be fine.

thanks

Dave

You have corruption in your database. This site will explain it and show
you how to fix it.

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

Hi! i'm encountering a rather strange but annoying problem. i have an Access
dbase with linked tables, & created forms to run some reports.

all works fine, but once in a while, when i try to access the VB Code I get
an error 'Error accessing file. Network connection may have been lost'.
i checked the network and could access the network drive where the access
dbase is stored.

Since i had a backup of the access dbase in the same network folder, i tried
it out. i can access the same code but without any problems.

so, each time i'm getting this error, i revert back to the last backup & use
that.

any ideas what could be causing this annoying problem?

regards,

Dave