For an Access 2003 application, how can we tell how it connects to it’s Sybase Datasource?

We have a legacy MS Access 2003 application.

How can we tell how it connects to it’s Sybase Datasource?
zimmer9Asked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
That might be a complicated question, but for starters, you can look at the tabledefs connect property:

1. Go to the VBA edit (Alt/F11).
2. Bring up the debug window (Ctrl/G).
3. Type

? CurrentDB().TableDefs("mytablenamehere").Connect

 and hit return.

 The driver may or may not be listed depending on the connect string (it may point to a DSN which has the driver info).
 
 It will start with ODBC though.

 copy and paste what you see here.

Jim.
1
All Courses

From novice to tech pro — start learning today.