?
Solved

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

Posted on 2010-11-20
8
Medium Priority
?
925 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:PDSWSS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 34180374
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
 

Author Comment

by:PDSWSS
ID: 34180384
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
 
LVL 77

Expert Comment

by:peter57r
ID: 34180388
How are you trying to set up the links?
0
Four New Appliances. Same Industry-leading Speeds.

But don't take it from us.  The Firebox M370 is Miercom tested and Miercom approved, outperforming its competitors for stateless and stateful traffic throughput scenarios.  Learn more about the M370, M470, M570 and M670 and find the right solution for your organization today!

 

Author Comment

by:PDSWSS
ID: 34180396
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
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 34180409
You need to delete all the (linked)  tables from the front end and then add the links again through External Links.
0
 

Author Comment

by:PDSWSS
ID: 34180423
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
 

Author Comment

by:PDSWSS
ID: 34180612
External links were no problem. Thank you very much for helping me solve this very frustrating problem.
0
 

Author Closing Comment

by:PDSWSS
ID: 34180613
Thanks again.
0

Featured Post

Threat Trends for MSPs to Watch

See the findings.
Despite its humble beginnings, phishing has come a long way since those first crudely constructed emails. Today, phishing sites can appear and disappear in the length of a coffee break, and it takes more than a little know-how to keep your clients secure.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The well known Cerber ransomware continues to spread this summer through spear phishing email campaigns targeting enterprises. Learn how it easily bypasses traditional defenses - and what you can do to protect your data.
What's worse than having your data encrypted by ransomware? Getting attacked by a so-called "wiper," which simply destroys the data and offers you no hope of ever seeing it again.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question