• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

Access 2007 Multiple Instances?

I have a program that ties to an MDB database which is protected by a password. When I input the password, I am able to access the tables, but the data in them is not my data. This is definately the correct database file, so where could my data be? Is it possible to have multiple instances of an MDB file, controlled by the password? What could be going on here?
1 Solution
Basic question, but are you sure you are using the correct file?  Are you using an old version of the database file?
Richard DanekeTrainerCommented:
Yes, you can have multiple copies of an Access database that have the same password.   When an Access file is copied, it includes the data and the password protection.  You are looking in the correct place after opening - checking the tables.  
I would continue to search for other Access files to locate the database with your records.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<This is definately the correct database file, so where could my data be? >>

  If your opening the correct DB file, then the only other explaination is that your using linked tables, or tables opened via code (ie. ADO) and one way or another, your not getting pointed to the right place.

  If your using linked tables, check where they are pointing to with the linked table manager.

  If your tables are being opened in code with ADO, you'll need to poke through the code to find the connect string.

JP_TechGroupAuthor Commented:
Just figured this out a few minutes ago! Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now