[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • 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?
0
JP_TechGroup
Asked:
JP_TechGroup
1 Solution
 
wkcarlsonCommented:
Basic question, but are you sure you are using the correct file?  Are you using an old version of the database file?
0
 
Richard DanekeCommented:
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.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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.

JimD.
0
 
JP_TechGroupAuthor Commented:
Just figured this out a few minutes ago! Thanks.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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