Data source name

[Jess]

I have an Access database talking to an oracle Database through an ODBC
driver. The connection to Oracle (links to the actual tables) has been
established through the access link manager. Is there an access property
featuring the “name of the data source†DSN my database is talking to? The
access property CurrentProject.Connection does not seem to have this
information.

It is crucial for me to know the data source name since I am using two
environments production and test.

Thanks

 

[Douglas J. Steele]

Are you talking about linked tables? Look at the Connect property of one of
the linked tables.