MS Access Database - Password protection

[Tican]

I'm not too sure if this should be in here or in HTML, Graphics & Programming.



I am creating an access database, and with certain staff memebers on site, they like to go snooping around databases etc

So what I would like to know is there a way of password protecting all the relevant forms so they can't access them - maybe a username and password for the people who need them, but I am not sure how to set these up!!! - only the ones I allow (one form out of them all!!)

TIA

Edit:

Or just disable the Database screen that allows you to go everywhere?

 

[Dolph]

You can easily do both.

Under tools, startup options, you can hide the database screen and set it to open a form automatically on opening the database.

If you want more security, look into the 'user level security' options, this enables you to create a workgroup with usernames, passwords and access levels, and assign rights to groups or users to run, edit, manage and so on all the componants of the database.

The only time user level security can be a pain is if you're regularly pulling the data into excel, as you have to start delving into VB code to get the access correct rather than just using the import data wizards.

 

[Tican]

You can easily do both.

Under tools, startup options, you can hide the database screen and set it to open a form automatically on opening the database.

If you want more security, look into the 'user level security' options, this enables you to create a workgroup with usernames, passwords and access levels, and assign rights to groups or users to run, edit, manage and so on all the componants of the database.

The only time user level security can be a pain is if you're regularly pulling the data into excel, as you have to start delving into VB code to get the access correct rather than just using the import data wizards.

If I untick the "Show Database" thing, how can I open it again once thats done (as I don't think you can pull the Startup menu up once that has done) - Ignore, sorted that one!!

I think I will look more into the User Level Security, as that sounds more suited to my needs

Thanks,

 

[Dolph]

I actually find the MS site one of the most helpful when it comes to access queries.

http://office.microsoft.com/en-us/access/HP030704101033.aspx

(Might need to change the version if you're not using access 2003)

That's a good place to start for user level security.

To answer your other question, press shift when opening the database

 

[Tican]

I actually find the MS site one of the most helpful when it comes to access queries.

http://office.microsoft.com/en-us/access/HP030704101033.aspx

(Might need to change the version if you're not using access 2003)

That's a good place to start for user level security.

To answer your other question, press shift when opening the database

Ooo Didn't know about holding shift!

Yes I am using 2003,


Thanks a lot for your help

 

[Dolph]

NP, happy to help. the shift thing works with user level security as well, press shift when ok'ing your password

 

[Tican]

NP, happy to help. the shift thing works with user level security as well, press shift when ok'ing your password

Nice one!

I now have it set up how I wanted it

Nearly ready to go 'live'

 

[londonbairn]

I made a CRM for someone in Access/VBA and I hosted the data on a share, so basically people with no rights to that directory cant see any data, at best the front end with no data.