Solved

Access FE/BE Password

Posted on 2011-09-27
5
244 Views
Last Modified: 2012-05-12
Experts,
I want to reset my password on a FE/BE Access DB.  I opened the BE and reset the password.  My problem is I am not sure where I set the password for the FE.  I was thinking it was on the linked table manager, but I am not finding it.

Help please...thanks,
Bob
0
Comment
Question by:RobertStamm
  • 3
5 Comments
 
LVL 18

Expert Comment

by:Richard Daneke
ID: 36711644
It would be on the FE database.  Open the FE database, you should be challenged with a password.  Once open, you should be able to change the password.
0
 
LVL 84
ID: 36711713
What version of Access are you using? In 2003, you can change the password under the Tools - Security menu. In 2007/2010, it's in different locations:

Click the Database Tools ribbon item, then click "Decrypt Database" and enter your password. Then click Encrpyt Database and enter your new password.



0
 

Author Comment

by:RobertStamm
ID: 36711751
I am using Access 2003.  The FE had no pwd on it just the BE.  I thought I had to enter the pwd as I linked the tables from the BE.  Not 100% sure.
0
 

Accepted Solution

by:
RobertStamm earned 0 total points
ID: 36711788
Ok...I just found it.  Delete the table from my FE first.  When you re-link the table from the BE you are asked a pwd.  Soluved my own problem.

Thanks all.
0
 

Author Closing Comment

by:RobertStamm
ID: 36929311
Self-answered
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

757 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

20 Experts available now in Live!

Get 1:1 Help Now