Finding Database Root Directory

[Guest]

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

 

[Rick Brandt]

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

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.

 

[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.

Well, more exactly:

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