notconfident
Programmer
I have an access accdb database created in Access2007. It is loaded on another Access2007 PC in the office where it is shared by 2 other PCs using Access2010.
It has been running fine for years with around 11,000 records.
Lately we have encountered a bug which has happened on two occasions weeks apart.
The database created a MSysCompactError table saying "Unrecognized database format 'Z:\Backup of MyDatabase.accdb'." - ErrorCode -1206. Plus it created a backup of the database.
Z: is the Folder on an Access2010 PC referring to the Access2007 PC where the database actually sits.
On the first occasion 3 records had ALL string fields replaced with #. If it was a field of say 10 characters it would now contain 10 x character #. The greatest number of ## was 16 even if the field could hold more so the record was effectively lost. On the second occasion 2 records were affected.
To "fix" the problem we deleted the bad records, ran Compact and Repair and the database would be ok again !!!
We cant work out what was actually happening at the time but it looks like the PC that was using the database appears to work ok its just when another user tries to open the database.
Each time I perform a mod to the programming of the database I run Compact and Repair to tidy things up but that is not when the error happens.
Any ideas ????
It has been running fine for years with around 11,000 records.
Lately we have encountered a bug which has happened on two occasions weeks apart.
The database created a MSysCompactError table saying "Unrecognized database format 'Z:\Backup of MyDatabase.accdb'." - ErrorCode -1206. Plus it created a backup of the database.
Z: is the Folder on an Access2010 PC referring to the Access2007 PC where the database actually sits.
On the first occasion 3 records had ALL string fields replaced with #. If it was a field of say 10 characters it would now contain 10 x character #. The greatest number of ## was 16 even if the field could hold more so the record was effectively lost. On the second occasion 2 records were affected.
To "fix" the problem we deleted the bad records, ran Compact and Repair and the database would be ok again !!!
We cant work out what was actually happening at the time but it looks like the PC that was using the database appears to work ok its just when another user tries to open the database.
Each time I perform a mod to the programming of the database I run Compact and Repair to tidy things up but that is not when the error happens.
Any ideas ????