I
Italian Pete
I have an Access Project front end connected to an SQL Server database. The
connection between the two is set in the "Data Link Properties" . The whole
thing works fine. However, the connection drops after about an hour or so on
one of the user's machines and data can't be saved to the tables. (Data is
saved by passing values from the front end form as parameteres to Stored
Procedures on SQL Server).
How do I check the connection, and how do I reconnect?
many thanks,
Pete
connection between the two is set in the "Data Link Properties" . The whole
thing works fine. However, the connection drops after about an hour or so on
one of the user's machines and data can't be saved to the tables. (Data is
saved by passing values from the front end form as parameteres to Stored
Procedures on SQL Server).
How do I check the connection, and how do I reconnect?
many thanks,
Pete