Perhaps a stupid question but why do Access databases develop corrupt records or in some cases the whole database?
For instance if two groups of users are using identical databases at different locations are there any likely reasons why one would have such problems?
Is this a bug with Access on networks?
Sorry should have mentioned that the database is split, all the users swear that they didtnt do any thing silly like turning their computers off at the wall.
Ive been advised that optimistic locking on the network greatly increases any corruption problem and to enshure the latest patches are installed Jet4 SP 6 + Office 2k SP3. It seems that only mdac2.5 and office SP1.3 are installed
This problem seems to happen most days at the moment so i dont think its a data collision/random network chance type of thing but some flaw in the database?
1)Determine if this happens from one machine or both
2)Does the corruption happen at about the same time of day (maybe during a backup?)
3)Ask users to be more aware of when it might happen (same process)
4)use jetcomp to repair and comapct all the databases in qusetion
5)Check to see if users of other apps are experiencing anomalies
6)Sometimes renaming the making a copy of the mdb and renaming the old one to databaseName_old.mdb will will alleviate the possibility of the mdb being on bad sectorws of the drive
Consistent corruption means a pattern - you need to identify the pattern
But I strongly reccommend using jetcomp