network drives

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am accessing a database over a network. The database resides on machine A, I am accessing it on machine B. The database needs to interogate a file located on machine A, the same machine and drive on which it resides. Could anyone tell me if it is possible, once the database is open, to obtain the full path to the database within my program? I can then use that to point to the file. Obviously I know the path but I dont want to hard program it, because the location of the database (and the file) may be changed at some point.
 
currentdb.Name will give you the full path to the current database. On my PC the result from the immediate window is:

print currentdb.Name
C:\Data\UsefulDatabases\Collections\CollectionsWithCmnDlgAPI2002.mdb

You can parse the string to extract just the path.
 
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

Linking tables 0
Am I disturbing a machine in production floor if I access its database remotely? 4
Migrating to New Computer 2
Server location of Access Database 2
Linked table on shared computer 2
Access 2007 Trusted Sites 9
Link table error for users at second location 1
How to ref. a file on another computer. 1

Back
Top