Password on database - allow users to open front-end w/o password

G

Guest

Help. I've got everything setup the way I want where the users are locked
out of everything and all menus when they open the application. They cannot
get to the database unless they know the bypass (Shift) on open. I went to
put a password on the database thinking that would prevent the users from
being able to access the tables, forms etc. should they happen to know the
bypass, but now it's prompting the average user for the password.

How do I lock down the toolkit/database yet still allow the users to open
the application without a userid or password? This is not really a secure
system perse, I just don't want anyone messing with the backend.

Thanks!
 
J

Joan Wild

You can put a password on the backend mdb. Then open the frontend and
delete the linked tables. Re-create the links; you'll be prompted for the
backend password, which will be stored with the new links - no prompt for
your users.

Another thought - you could disable the shiftkey bypass if you think your
users will learn this (which they likely eventually will).

Look for By Pass Shift Key Code on this page
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
for a utility you can use to turn it on/off.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top