Database Needs to be Repaired

[Dwight]

I am testing a new application in a multi-user enviroment.

I am getting an error that I did not get when I tested it
on a single-user enviorment. The error is as follows:

********************************************************
The database "I:\database.mdb" needs to be repaired or
isn't a database file.

You or another user may have unexpectedly quit Microsoft
Access while a Microsoft Access database was open. Do you
want to repair the database?
*********************************************************

I click yes and the database does repair ok.

Micorsoft Access is loaded on local PC and the database
(.mdb) is loaded on the network.

Does anyone know what might be the cause of this error.

Thanks in advance!

Dwight

 

[Nikos Yannacopoulos]

Dwight,

If you intend your db to be milti-user, the first thing you should consider
is splitting it to a Front End / Back End scheme (from your posting I guess
you haven't). Browse through the multiuser NG, you'll find a lot of
interesting stuff there!

Now, the reason why you got this message could be either what is suggested
by the message (abrupt user termination), or a network problem, or... A
well designed FE/BE scheme will make corruption a much less frequent
occurrence (though there's no guarantee it will never happen).

HTH,
Nikos