ODBC Check

[Guest]

How can I determine what ODBC Data Source is actually being used in an Access
application???

And how can I change the ODBC setting so that I can test an Access
application to a test data source???

Any help would be GREATLY appreciated.

Thanks!

wnfisba

 

[Arvin Meyer [MVP]]

Open a table in design view, right-click on the titlebar and choose
properties. The first property in the list is the connection string. It will
name the DSN being used. Opening that DSN in the control panel will give you
the database and path information.

In DAO, you can use the Connect property of a TableDef to find the
connection string.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access