Password Protect Back End database ?

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

Gulf Coast Electric

Can I password protect a db that is already linked? i.e. split
I just want to password protect the back end.
I tried setting a password for the back end, but it said wrong password when
I opened the front end.
 
I usually just add a small form to the back end database. I set this form as
the start-up form.

The msgbox looks "just" like a system message box, and I simply give the
user the following message:

You don't have permissions to open this datafile

The user then clicks ok...and I do a application.quite and the application
closes.

Unless the users know about the shift-key bypass, then the above is usually
more then enough to keep users out. And...for good measure...you can turn
off the shift key also.

of course, my users all get a shortcut to the "front" end database, and
never really know, or have learned about the backend part anyway (likely,
you started out with users having to know, or see or learn about the
existence of the backend...and that should have never happened in the first
place. However, the above simple form "boot" users out trick works very well
indeed.
 
You would need to delete the links and recreate them. You'll be prompted
for the password for the backend, which will be stored in the new links.
 
Back
Top