How to create a username and password in Access

[How to create a username and password in]

I have created a database with all the functionalities in it. I am now
interested in creating a username and password to allow administrative staff
to access it.

[Keith Wilby]

On 18 May, 14:41, How to create a username and password in <How to

Post by How to create a username and password in
I have created a database with all the functionalities in it. I am now
interested in creating a username and password to allow administrative staff
to access it.

What version of Access are you using?

www.keithwilby.co.uk

[John W. Vinson]

On Tue, 18 May 2010 06:41:01 -0700, How to create a username and password in

Post by How to create a username and password in
I have created a database with all the functionalities in it. I am now
interested in creating a username and password to allow administrative staff
to access it.

If this is a .mdb file in A2003 or earlier, you can use Workgroup Security.

Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

If it's 2007 and a .accdb file, password security is not supported. You should
split the database into a frontend and backend
(http://www.granite.ab.ca/access/splitapp.html) and just give the staff a copy
of the frontend.