Hi there, we have a database that users are writing to through an excel form. We have been successfully writing to this for months however we have now run into a problem...
We have tried opening the database outside of the timeframe that users can write to it and are getting an error:
"The Database R:\...mdb' needs to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want to repair the database?
The problem is:
1. The excel form that writes to the database still works. This form inserts a row into a table and then checks that this record exists. When we insert a record the ldb files last updated time changes to the present time.
2. We tried zipping the database, unloading it on a different server and then repairing it. This worked however none of the records insert over the past few days are existant, and the database descreases significantly in size.
I believe the records are in the database as we can still write to it through the excel form which is checking that the record is properly inserted.
Any ideas on how we can recover this data? I tried running a spreadsheet that would select everything from the table but received an error when trying to connect to the database.
Thankyou kindly for your help this problem is driving us nuts!!!
Cheers
Tony
We have tried opening the database outside of the timeframe that users can write to it and are getting an error:
"The Database R:\...mdb' needs to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want to repair the database?
The problem is:
1. The excel form that writes to the database still works. This form inserts a row into a table and then checks that this record exists. When we insert a record the ldb files last updated time changes to the present time.
2. We tried zipping the database, unloading it on a different server and then repairing it. This worked however none of the records insert over the past few days are existant, and the database descreases significantly in size.
I believe the records are in the database as we can still write to it through the excel form which is checking that the record is properly inserted.
Any ideas on how we can recover this data? I tried running a spreadsheet that would select everything from the table but received an error when trying to connect to the database.
Thankyou kindly for your help this problem is driving us nuts!!!
Cheers
Tony
