Front End/Back End Password Question

[AccessNub]

Hi All,

I am using a front end/back end Access Database.

On The backend I have a user/password table that is password protected so only the admins can modify the data there.

What I am trying to do is use a form on the front end database that can access this table.

Is there a way to make the front end form enter or prompt for password for the back end table?

 

[agehoops]

Would it not possibly be easier to simply password protect the form itself rather than the table? And just have the back end hidden to all users so they cannot access any of the tables?