If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ODBC connection fail - linked tables. Please help.
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. |
#2
|
|||
|
|||
ODBC connection fail - linked tables. Please help.
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. "osupratt" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|