| | |
|
|
|
Repairing every hour? |
|---|
| message from Dale on 18 May 2004 |
file. You or another user may have unexpectedly quit MS
access while an access database was open. Do you want to
repair database?."
violation with the machine number that corresponds to my
own desktop...and I'm not even in the application.
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?
contention with myself when trying to repair the database?
|
| Albert D. Kallal replied to Dale on 18 May 2004 |
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
|
|
Archived message: Repairing every hour? (Microsoft Access Error Message)
