Linking Access MDB to a SQL Server database in a multi user envirnment

[phweston]

I am in the process of setting up a SQL Server Database with a Access Front End. I have 4 people who are going to share this database.

I set up the security so that each person has his/her own log inand Password. We did this to because we have Audit trail triggers set up to track any changes

The proble that I am having is that when one person goes in under his/her login, other people are locked out and get ODBC Connection Fail Message, requiring them to go into Linked Table Manager and re-link the tables for themselves.

1. We need to be able to share the database
2. We want it so that the users do not have to go in everytime and refresh the linked tables.

Any suggestions?

 

[JerryKlmns]

I can't help you with the problem you are facing but I wouldn't share the database since the sharing of data happens in the SQL Server database. What else is there to share?