Log users

[sandrao]

We reciently had a problem with a database. It became corrupt and we can't
access it. Is there any why that I could find out Who was the last user, the
problem that occurred.

Could the problem be logged in a place other that the databse being used.
If the info is kept in the database being used and it becomes corrupt I still
wouldn't know what and who caused the problem.

 

[Joan Wild]

It's not likely you can tell who caused the corruption. If there is a ldb
file in the folder where the mdb is located, that'll tell you who had been
using it, but that may not be of much help.

You might be able to repair/recover the database. Copy it first.

Try compacting using Jetcomp, available at
http://support.microsoft.com/?id=273956

If that fails, try creating a new database and importing objects from the
old.