Using VB6 with a MS Access database back-end: configuring access levels

[ukrutter]

Any help would be greatfully recieved here! I'll try and explain the situation here...

I have a database in Access, which is in essence a booking system. I am using VB6 to link to this database. There are people that log onto this system.

The problem / question:

The people that use this database have different access levels. I have some people who I want to have "read-only" access, some people I want to give them "Read / Write" access to, and some people I want to give them "Full Control" access to.

If the level of access these people should have is in the database, and their login details are on this database, how can the access levels be incorporated into VB?

Do I need to create different "classes" of users to this database? I'm not sure where to start.

[willakawill]

Hi a security table with levels of access is simple enough. assign the levels of security to each login and keep that level of security on a global variable. Test the variable each time they call the db and control the read write capability in vb, not in access. It is not a simple switch on/off thing. You will have to control the entire app in code.

This can be done at the db level using workgroup admin. I am not a fan of that route. I prefer to do it in code

[ukrutter]

Hi a security table with levels of access is simple enough. assign the levels of security to each login and keep that level of security on a global variable. Test the variable each time they call the db and control the read write capability in vb, not in access. It is not a simple switch on/off thing. You will have to control the entire app in code.

This can be done at the db level using workgroup admin. I am not a fan of that route. I prefer to do it in code

Do you mean "do it in code" at the VB end?

[willakawill]

Do you mean "do it in code" at the VB end?

Yessir. That is always my preference.