Controling user access to ceratin areas of database

[hawg1]

Hi,

I'm trying to come up with the best way to limit users access to certain areas of my database.

For example, I want only training managers to have access to the "training" menu item on a customized menu bar (and everything else on the menubar) and general users access to everything but the "training" menu item ('training' grayed out and non-selectable) on a customized menu bar.

I created an option group on a form to identify the 'areas' a user should have access to (ie trainning manager, user, etc) and stored the numerical value in a table. From here I'm at a loss. Is this a permissions functions, security function or something else entirely?

Words of wisdom and advice greatly appreciated.

Thanks in advance

Hawg1

 

[Dennisk]

permissions allow users various levels of actions with the data ie add/delete/edit etc.

Also you can grant open permissions from the database down to forms /queries/reports/code etc.

So search the forum for security or workgroup.

 

[hawg1]

Dennisk,

Thank you for the reply and the useful information.

Hawg1

 

[edojanssen]

Take a look at http://www.pcmenu.info/download/InlogMenu.zip.

This mdb uses a log in to give users certain permissions.

Edo

 

[dan1dyoung]

Try this, it was from this site if i remember but it is great.

Log on as:

Username: test1
Password: test1

and

Username: test2
Password: test2

under test1 you will have the accounts button enabled as you are a member of the admin groupo, test2 does not as it is the user group.

Look at the forms code for that button to see how it is limited by the user group ID.

and if you are going to use a custom toolbar then look at the menu enable.desable sample (Also from this site)

 

[hawg1]

edojanssen,

Thanks for the info

 

[hawg1]

dan1dyoung,

thanks for info, I will look at both of those files