ODBC Connection failing with multiple users

[phweston]

I am in the process of setting up a SQL Server Database with a MS Access Front End. The problem that I am having is that when someone else is logs into the database, myself or someone else gets a Connection Fail Error and needs to re-link the tables using the DSN I set up. Once I do that, the first person who was in gets the Connection Fail Error.

Any suggestions? We want to have multiple log ins because we want to track changes to the database using triggers and audit trail tables.

 

[genomon]

SQL Server sounds as if it is not congigured for multip[le users, or you only have a single-license installation.
Check out the FAQs in the SQL Server forum for more help...

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.