Microsoft Access - Records Lost?
Posted on 2012-03-14
Hope you can help!
Our school maintained an an Acess database for many years. The program version was (possibly) Office 2003 as the file appears to have been created in 2007. The database was regularly updated on a machine that originally ran Office 2003 and was upgraded to 2007. However, conversion of the file to 2007 format was never carried out. The file was stored on a shared drive on the server.
The old server was replaced 2 days ago with a new server and all files were copied from the old server tot the new server - including the database.
Now when I open the database, I can only find 527 of the 1000 records that were in the original file. I have made a copy of the old file and run a conversion to Office 2007 on this. Result was the same. On first opening the converted database, I did get a warning that certain content was blocked and and I opted to view this content.
Substantive searches on both the Pc and the server have failed to turn up another acopy of this database
Could it be possible that because the conversion had not taken place on the original database (from 2003 to 2007), that this could be the cause of the problem? The Secretary and I had views the database prior to the change-over and the records were there?
Can anyone help?
Thanking you in Advance - With Confidence