Very nice complex database recently uploaded to Sharepoint so I am using linked tables. I want to distribute this for wider availability, but due to sensitivity issues, I do not want "Bill" to have access to view "Jim" and vice versa.
Our Sharepoint automatically logs users in via a digital Common Access Card.
So when they open up the frontend database, their CAC login would give them permissions to the sharepoint linked tables, and the forms and reports would be queried based upon BILL or JIM..
Not sure if that makes sense..
I could recreate the entire database for each person who needs it, changing queries for each one, but when I make one change to MY copy of the database, I would have to go in and import to each subsequent, then update the query again, etc..
Is this more a Sharepoint issue?