Forum Discussion
Tables Lost from Database After Copying
We sell and support an environmental monitoring database that has an Access front and back end. The back end stores the data are for various projects and can be swapped out in the front end to provide the output. There are almost 200 tables in these back end files.
We have a client that has been moving the back end databases from an Azure Windows VM to his local computer to work on them. When he tries to use a copied database, he gets an error and it appears that the database has "lost" a number of tables. This has happened several times in the last week. This problem has only occurred on the local computer.
While we have backups to restore these files, we have never encountered this before. Has anyone else seen this happen and if so, any suggestion on finding out what causes it.
5 Replies
- How is your client "moving the back end databases from an Azure Windows VM to his local computer"?
I'd highly suspect a user/usage error.
Can you detect any pattern to the missing tables?
What software are they using?Daniel_Pineault I agree with your suspicions but I have an angry client that thinks our software doesn't work. Some databases lost a few tables and others up to 20. Each appeared to be independent from the others. The client got an the “Automation Error” was likely caused by the missing tables and then ran Compact and Repair which didn't help. He then attached to another database and had a similar problem.
This is Office Access 365. For information on our software see https://geotech.com/products/envirodata Both the front and back end are Access MDB files.
- Your best bet would be to do a remote session with your client and get them to show you exactly what steps they perform to copy their database so hopefully you can identify the issue.
