Solved

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

Posted on 2010-11-20
8
904 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
  • 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
 

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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 77

Accepted Solution

by:
peter57r earned 500 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now