Solved

Access FE/BE Password

Posted on 2011-09-27
5
286 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
[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
  • 3
5 Comments
 
LVL 19

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 85
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

724 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