By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,044 Members | 1,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,044 IT Pros & Developers. It's quick & easy.

network error has corrupted database

P: 35

I'm implementing a really simple access DB on a server. Every once in a while, an error will occur that appears to cause an unrecoverable flaw in the program code. This error crashes the DB. It deactivates control buttons and does not allow me to add new controls to existing forms. I'm getting the message:

"error accessing file. Network connection may have been lost"

i've tried compacting the DB and still no luck. This has been a disaster. Does anyone have a recommendation on how to fix?


May 1 '09 #1
Share this Question
Share on Google+
4 Replies

Expert 100+
P: 1,287
Last time I was working on a database and a network admin reset the server, my database was corrupted beyond recovering, and I had to revert to the previous day's backup.

But you can try the steps in this Bytes post to decompile, if your database is corrupted.

Do you think it is possible that the network connection was actually lost?
May 1 '09 #2

Expert Mod 15k+
P: 31,761
Network connections dissappear all the time. For various reasons. Depending on timeout values etc.

It's a good idea to plan for this by using a Front End / Back End (Front-End / Back-End (FE/BE)) setup where the FE databases are stored on the local PC.

BE connections are not so critical. It is the connection to the designs etc which cause the problems when encountered.
May 1 '09 #3

P: 35
thank you both of you! again, i am humbled by your knowledge and generosity. Todd
May 1 '09 #4

Expert Mod 15k+
P: 31,761
You're welcome Todd.

It's always nice to deal with members who show such good manners :)
May 1 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.