Microsoft Access - Records Lost?

Hi Experts.

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?

Real Mystery!
Can anyone help?

Thanking you in Advance - With Confidence

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

If the records have truly been deleted then there is no way to recover them.

Are you absolutely sure you are comparing apples with apples and not , for example, comparing the results of a query with records in a table?  

Are you able to identify specific records thaty are missing?  Is there any pattern to the missing records - ID numbers above a specifc value? ....all have a particular value in one field?

Does your application involve deleting records at all?  If so, how can you be sure they have not simply been deleted?  
Are the missing records 'child' records of the same 'parent' in a database relationship that has been set up with cascading deletes?

Have you loaded a recent backup and compared that with your current file?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Also - what operating system was the old server, and what OS is the new one? If you're running an OS that utilizes folder redirection or virtualization, you might simply be looking at the wrong file.

Did you make a copy of the database BEFORE the server move? If so, can you move that copy off the server to your local machine and review it there?

Same with the current database - move it off the server, and examine it on your local machine.
Jeffrey CoachmanMIS LiasonCommented:

I'm just thinking you copied an older file...

Trust me, I know how confusing things can get with multiple backups and multiple names, multiple reference copies, multiple front ends and multiple back ends...

The fact that Access update the "Modified" date anytime you open the DB, may have signaled to someone that an older file was actually the most recent.
For example, the question is:   What is the most current DB?
Three files (in a certain folder) may have similar dates.  So each one is opened and inspected.
Now each of those files has virtually the same date.
Now someone simply grabs the file with the most recent date.

Meanwhile the files they opened were not even in the correct folder as the "Actual" file...!

Make a solid back up of the entire old drive and search it thoroughly....

Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

freshfordianAuthor Commented:
Jeff. You are correct!

As it has turned out over the past few days, this file is not the only one to have "disappeared". In fact a serious issue has emerged.  The machine on which these files were stored was part of a domain, A remote backup is carried out on the server daily and user data files should have been stored on the server for inclusion in the backup.   This was not done Before the machine was  disjointed from the old domain, all the files were backed up -but a profile was missed! I believe now that within that profile is the file and many others that are now missing. Because the machine has since been joined to a new domain, I'm now afraid that we have lost all these files.  Is there anything we can do?
Jeffrey CoachmanMIS LiasonCommented:
Sound pretty bleak.

I though you stated:
<The file was stored on a shared drive on the server.>
...Then there should be a backup somewhere...

Again, search the Shared folder/Drive *thoroughly*...

You may have to open multiple databases to check for the missing records, but at least you will be sure, one way or another...
freshfordianAuthor Commented:
Found them!

I assumed that the files were on the server as Drive z was a mapped drive.
However, I checked the registry if the client Pc and discovered that z pointed to a folder located on a NAS drive  Once the Folder was examined all the files were found

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
freshfordianAuthor Commented:
The Experts comments were helpful and solid inview of the infornation I had provided them.
The registry search carried out by self ( more out of desperation than any solid technical reasoning) helped me find the path to a NAS drive - not the server as first assumed.  This may help other members in the future. i.e. Carry out what the experts suggest but also check the registry. It can help and it did in this case
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.