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

network error has corrupted database

P: 35
Hi

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?

thanks

todd
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.
http://bytes.com/groups/ms-access/70...s-2007-anomaly

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

NeoPa
Expert Mod 15k+
P: 31,347
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

NeoPa
Expert Mod 15k+
P: 31,347
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.