ODBC connection fail - linked tables. Please help.

[osupratt]

I am at a deadline here and don't know where to turn. I inherited an Access
front end with SQL Server 2005 back end. It is a Ticket System. There is a
Form for new tickets, a form for Edit old tickets, and a Switchboard. The
only issue that I'm having is that there are two fields on the forms that the
tables are linked to the back end. Each time I get out of Access and get back
in there is an "ODBC -- connection to 'update' failed" error box that pops up
when trying to enter data at these fields (they are combo boxes that are
built off of queries that are looking up Customers, etc). I can go into
Linked Tables manager and refresh and it works fine until I get out of Access
and back in.

This is going to be on my network and is going to be used by more than one
location and more than 20 people. I am very new to this and really don't have
a clue. Someone told me I had to code a connection string. Of course I don't
know what the code would be or where to place it. Any help with this problem
would be greatly appreciated.

I did look at other postings and nothing was what I think anyways close to
what I'm dealing with here. Sorry if I missed one. Thanks.

 

[Golfinray]

I use a sql back end with an Access front end and connect using ODBC. When
you get that "update" error you have lost contact to the sql back end. Once
you log in it should stay connected until you log out or lose connection. We
do not use an automated system for users to log in - they have to log in
every day or after each logout. I looked on the Internet and saw that people
do have some automation techniques posted so that users are automatically
logged in when they pull up a form. If you don't get someone here to help
with the code, you might try there.