Database needs to be repaired

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 22 Sep 2004 23:54 GMT

I have a lot of users entering data on forms and it seems
my database is always telling me that it needs to be
repaired. So I have everyone get out and hit the repair
button. I have tried to troubleshoot by having two
computers fill out the forms and close at the same time
but that doesn't seem to be the problem. Is there some
type of log file that will tell me what error out or what
happened?

Thanks for your help.

Reply to this Message

Lynn Trapp - 23 Sep 2004 13:05 GMT

No, there is no log file to store that kind of information, unless one was
created by the developer of the database. It doesn't happen automatically in
Access. Also, the causes of corruption in Access can be pretty hard to track
down. Tony Toews has a webpage that lists some of the most common causes and
some possible fixes.

www.granite.ab.ca/access/corruptmdbs.htm

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> I have a lot of users entering data on forms and it seems
> my database is always telling me that it needs to be
[quoted text clipped - 6 lines]
>
> Thanks for your help.

Reply to this Message