Passwords

N

Neil Greenough

I will be splitting up a database and will be putting the backend on a
server drive and the front end on certain individual's desktops. Now, I
would like to password the whole backend of the database just in case
somebody manages to find it and play about with it. Nonetheless, I don't
want to put a password on the frontends, nor do I want the users to be
prompted for the backend password when they open the frontend.

Is this possible? If so, how?
 
A

Arvin Meyer

It's possible, but with the security system of the server. Put the back-end
in its own folder and secure that folder giving read, write, and delete
permissions to only the group of users permitted in the database. Deny any
permissions to anyone else.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
N

Naresh Nichani MVP

Hi:

You could also apply a database password to backend - this password would be
stored in Connect Property of Front End table though - most users would not
look to find it as you need to know some VBA code for that. However this
could be a simple solution for you.

Open backend and click Tools | Security | Set Database Password...

Regards,

Naresh Nichani
Microsoft Access MVP
 
Top