Repairing every hour?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had created an Access 2000 application, which has given me the following error almost every hour:
"This mdb file needs to be repaired or is'nt a database file. You or another user may have unexpectedly quit MS access while an access database was open. Do you want to repair database?.

After selecting 'yes', I oftentimes get a sharing violation with the machine number that corresponds to my own desktop...and I'm not even in the application.

First of all, does anyone know why the database needs to be repaired so frequently? We only have about eight users in the application at one time. Granted they're adding, deleting or modifying records from the same table; but, Access should be able to process the requests sequentially, right

Second of all, does anyone know why I would have contention with myself when trying to repair the database

A quick reply is appreciated.
 
Phyllis said:
I had created an Access 2000 application, which has given me the following error almost every hour:
"This mdb file needs to be repaired or is'nt a database file. You or another user may have unexpectedly quit MS access while an access database was open. Do you want to repair database?."
Click to expand...

To add to Albert's reply the first thing to do after investigating the
splitting issue would be to set the OpLocks registry key on the
server. More info on that at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
-----Original Message-----
I had created an Access 2000 application, which has given
Click to expand...
me the following error almost every hour:
"This mdb file needs to be repaired or is'nt a database
Click to expand...
file. You or another user may have unexpectedly quit MS
access while an access database was open. Do you want to
repair database?."
After selecting 'yes', I oftentimes get a sharing
Click to expand...
violation with the machine number that corresponds to my
own desktop...and I'm not even in the application.
First of all, does anyone know why the database needs to
Click to expand...
be repaired so frequently? We only have about eight users
in the application at one time. Granted they're adding,
deleting or modifying records from the same table; but,
Access should be able to process the requests
sequentially, right?
Second of all, does anyone know why I would have
Click to expand...
contention with myself when trying to repair the database?
 
Do you have a proper multi-user setup?

A proper setup for multi-user means that each pc should get a mde file
(place on EACH pc). The data file can remain a mdb, and this part is placed
on the server and shared. This setup does not requite you change your code.

So, the first thing is to ensure you have a competent setup.

For info on splitting..check out:
http://www.granite.ab.ca/access/splitapp.htm


Once you accomplished the above...then you can check the following faq for
reasons of corruption:

http://www.granite.ab.ca/access/performancefaq.htm
 
Back
Top