Access FE/BE Password

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
Bob StammOperations ManagerAsked:
Who is Participating?
 
Bob StammConnect With a Mentor Operations ManagerAuthor Commented:
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
 
Richard DanekeTrainerCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Bob StammOperations ManagerAuthor Commented:
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
 
Bob StammOperations ManagerAuthor Commented:
Self-answered
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.