Connection in VBA

LadyDi

Registered User.
Local time
Today, 07:01
Joined
Mar 29, 2007
Messages
894
I have a database whose back end is on an SQL Server. I have several buttons set up on the database to update the tables. My problem occurs when the database seems to want the connection refreshed for every table it is trying to update. Is there a way to refresh an ODBC connection through VBA? I'm attaching a picture of the message box that keeps appearing. The user doesn't even have to sign in, they just have to mark the "use trusted connection" check box. Any assistance you can provide would be greatly appreciated.
 

Attachments

  • Connection Snapshot.jpg
    Connection Snapshot.jpg
    15 KB · Views: 52

Users who are viewing this thread

Back
Top Bottom