Display data based on user role

[Guest]

I have three separate db that all display the same fields, but different data
based on the product for the db. Since the Forms tables and Reports are
exactly the same regardless of user, i would like to combine the three db
into one for ease of maintenance. The only difference would be a query that
would determine what role the user is and therefore what product's data to
display.

Any suggestions on how to set this up?

 

[Armen Stein]

I have three separate db that all display the same fields, but different data
based on the product for the db. Since the Forms tables and Reports are
exactly the same regardless of user, i would like to combine the three db
into one for ease of maintenance. The only difference would be a query that
would determine what role the user is and therefore what product's data to
display.

Any suggestions on how to set this up?

I assume you are not using Access User permissions.

You can determine the user's Windows login with this code:
http://www.mvps.org/access/api/api0008.htm

Then, in an Access table, you can relate each Windows user to the
Product that they should be able to see.

When your forms and reports display data, you can use that table to
limit the products that they see.

Be aware that anyone with knowledge of Access would be able to
circumvent this, so you shouldn't use it for truly senstive data. It's
just a convenience feature.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com