losing odbc connection to sql server tables

[Guest]

we have an access database linked to sql server tables. everything has been
working well for a couple of years. recently, as soon as another user opens a
table, the other users have to relink,. this in turn causes the other users
to relink. because of this, only one person can use the database at a time.
any ideas?

thanks.

 

[Ron Hinds]

we have an access database linked to sql server tables. everything has
been
working well for a couple of years. recently, as soon as another user
opens a
table, the other users have to relink,. this in turn causes the other
users
to relink. because of this, only one person can use the database at a
time.
any ideas?

thanks.

You might want to try the microsoft.public.access.odbcclientsvr group...