I have a MS SQL 2000 server and I use MS Access XP as the front end using linked tables. I want to be able to create a login that allows clients to only see there information preferably using sql server authentication. I have a clientid table that is used to identify a clients information, all data for a client can be referenced back to that id, so is there a simple way to make a Access front end display only the data that is related to the clientid by referencing the sql authentication login?? Any other suggestions would be appreciated.
Thanks in advance for your time.