We have Access2000 database with around 18,000 records, shared from a server to around 7 people.
Access is set to lock the file for editing to prevent more than one person editing the same record.
Every now and then, we get the database reportingit is 'in a state' whichinevitably means it is orrupted and we have to reload the previous day's backup tape - quite often losing 4-6 hours worth of data.
Any ideas on why it's doing it and how to get around it?
Access is set to lock the file for editing to prevent more than one person editing the same record.
Every now and then, we get the database reportingit is 'in a state' whichinevitably means it is orrupted and we have to reload the previous day's backup tape - quite often losing 4-6 hours worth of data.
Any ideas on why it's doing it and how to get around it?