Finding Database Root Directory

H

Hilikus

Greetings...

I have a split DB... front end and back end...
Is there anyway to find out (through code) what directory either the front
end file or back end file is located?

I can understand that this could be irrelevant... but if it can be done,
please let me know...

Hilikus
 
R

Rick Brandt

Hilikus said:
Greetings...

I have a split DB... front end and back end...
Is there anyway to find out (through code) what directory either the
front end file or back end file is located?

I can understand that this could be irrelevant... but if it can be
done, please let me know...

Hilikus
Click to expand...

CurrentDB.Name
....will give you the full path and file name of the front end.

CurrentDB.TabelDefs("TableName").Connect
....will give you the path to the back end if you use a linked table's name for
TableName.
 
D

David W. Fenton

CurrentDB.TabelDefs("TableName").Connect
...will give you the path to the back end if you use a linked
table's name for TableName.
Click to expand...

Well, more exactly:

Mid(CurrentDB.TabelDefs("TableName").Connect, 11)
 
Top