Password protect

[Guest]

Hello. Im a new user. I have built a database and would like to save it on a
shared drive for myself and one other user to have access to. If I password
protect it will the both of us be able to update it at the same time. If I am
signed into the database and my co-worker trys to access the database will
he/she be promted to sign in. If anyone could be of help please let me know.

 

[John Vinson]

Hello. Im a new user. I have built a database and would like to save it on a
shared drive for myself and one other user to have access to. If I password
protect it will the both of us be able to update it at the same time. If I am
signed into the database and my co-worker trys to access the database will
he/she be promted to sign in. If anyone could be of help please let me know.

If you use the Database Password, anyone who knows the password will
be able to use the database. In fact, anyone who spends five minutes
searching the web will find "crackers" which can reveal the password;
it's about as secure as a $2.95 bicycle lock.

For a better option - but one that's tricky and a fair bit of work -
you'll want to implement Access Workgroup security. Go to

http://support.microsoft.com/?kbid=207793

and download the security FAQ. Read it carefully. TURN OFF YOUR
COMPUTER, sleep on it. Read it carefully - *again*. Secure your
database, following the steps in the FAQ *explicitly* - it's very easy
to do security wrong!

If you and your colleague will be sharing the database, you should
also use the Database Splitter Wizard to split the database into a
"backend" containing the tables, stored on a shared drive, and a
"frontend" containing everything else; you'll each get a copy.

John W. Vinson[MVP]