User view specific data

[clubinski]

Password Query

I am trying to limit what a user can see when accessing a database in access. I am only testing with this in access before taking it to SQL server. I have 3 databases and I combined the data into one set of tables and now what i am trying to do is a certain user can only view data from a particular database.

I have a table with the users id and password, as well as an ID number from each database that I am trying to tie to the users.

for example one user can view and add/edit data in databases 1 and 3 but not 2. while there might be a user that can view and add/edit on 1 and 2 but not 3.

Hopefully I explained that well enough for some help if not I do apologize.

Thanks,
Chris

 

[boblarson]

Re: Password Query

You'd be better off doing this straight in SQL Server as you can set permissions on various objects there that is more difficult to do in Access.

 

[boblarson]

1. Don't delete a thread if someone has responded.

2. It is going to be much more work to create all of this in Access instead of just going straight to SQL Server. It is going to take a LOT of work to set all of this up in Access.

You will have to change everything to go off of what they are allowed to see. You will need to validate that in every query, every form, etc.