Display Database Name

  • Thread starter Thread starter FSCHW
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#deleted 2
Access Access Report Works on One Machine but not Another 3
Database documenter 3
Need some help with reporting 0
Error 3298:More than one table exists with same name 2
Using multiple databases 3
Opencurrentdatabase (without open a new database) 0
Converting SQL Timestamp (Milliseconds) into usable Calendar date 1

Back
Top