Different interfaces for different users etc

[Ironis]

Hey there

I have a few questions, someone might now the answers..

I'm working on a reservationsystem, which needs to have multi-level users. Some users should only update and insert data, and shouldn't be able to read some data, like creditcardnumbers etc.

But there should also be a user, that can print several reports, like earnings etc, and there should be a user, that has access to all functions, and can read creditcardnumbers, but the rest shouldn't

Can i use different interfaces for different users, so that some users can only insert data on creditcardnumbers and not read it, or that users have different menus, depending on their access level..

Can anyone help me out with these questions? Feel free to ask for more details, if this isn't clear enough..

Thanks in advance

 

[John.Woody]

You could have one main menu, set user levels and dependant on the level of the user enable the relavent buttons on the main menu.

 

[Ironis]

Thats what I was thinking of.. But how can I manage that? Using a query or something?

 

[John.Woody]

You could create a users table which stores User Name, Password, Level (i.e. 1 =Access to All Areas, 2 = Access to some areas, 3 = Access to one area). Create a Logon form and subject to correct user name and password lookup the level and enable the relavent buttons on your main menu.

 

[JonH]

You could also create several mde files - one for each level of functionality.

 

[John.Woody]

Assuming the database is going to need further development and modification it would be much easier to modify one db rather than four. It would also stop a low level user going to a different PC and getting a higher level of access to the db.