How do you password protect back end databases in MS Access 2007?

I was given a database that has a front end (forms, tables, code, etc) and two back ends (tables, passwords,respectively).

I need to password protect the two back ends. If I link the front end to back end tables and then password protect the back ends (open exclusive and set passwords), I get  an incorrect password message when I try to open the tables from the front end. How can I set passwords in the back ends so that the back end tables can be opened via the front end?
Thanks
PDSWSSAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
You need to delete all the (linked)  tables from the front end and then add the links again through External Links.
0
 
peter57rCommented:
You have to apply the password to the backend first and then link the front-end to the backend tables - at which time you will be asked for the password.
0
 
PDSWSSAuthor Commented:
There lies the problem. It does not ask for the password when I attempt to link the tables. Instead  a window opens that says  "not a valid Password" when I attempt to link the tables. This apparently is not the expected behavior. Any idea how to fix this? Another MS bug?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
peter57rCommented:
How are you trying to set up the links?
0
 
PDSWSSAuthor Commented:
I open the front end, choose link table manager, choose the box to the left of each table I want to link, click OK and browse to the BE dB that contains those tables and click OK -

Then the password error shows up instead of asking for my password.
0
 
PDSWSSAuthor Commented:
I just deleted all the linked table and Link table manager is no longer available. How do I add the links back through external links?
0
 
PDSWSSAuthor Commented:
External links were no problem. Thank you very much for helping me solve this very frustrating problem.
0
 
PDSWSSAuthor Commented:
Thanks again.
0
All Courses

From novice to tech pro — start learning today.