Display Database Name

F

FSCHW

I have an access database, that links to Oracle Tables,
that I can point to several evnironments (production,
Development, Test). I'd like to create a query that I can
include into my reports that will display the environment
the data is coming from. I've tried using the currentdb()
function, but havae had no luck. Can someone point me in
the right direction?
 
D

Douglas J. Steele

You need to look at the Connect property of one of the linked tables:

CurrentDb().TableDefs("MyLinkedTable").Connect

Take a look at that, and parse out what you need to determine the
environment.
 
Top