D
dan
Hi;
This is my second attempt at this. I have a database
with a front-end and back-end. Checking to see if the
front-end is linked to the back-end table is NOT my
problem. I have code that does that and my tables are
linked properly.
What I want to do is just load a string variable with the
path/directory/filename of the back-end database. I can
do this for the front-end with this code:
Public glCurrentfe As String
Dim dbs As DAO.Database
Set dbs = CurrentDb
glCurrentfe = dbs.Name
The global variable glCurrentfe would now contain the
path/directory/filename of the front-end database. How
do I get a variable loaded with the back-end database?
I'm not interested in checking links or linking it
because it's already been linked. I just want to get the
path/directory/name of the back-end database into a
string variable.
Thanks,
Dan
This is my second attempt at this. I have a database
with a front-end and back-end. Checking to see if the
front-end is linked to the back-end table is NOT my
problem. I have code that does that and my tables are
linked properly.
What I want to do is just load a string variable with the
path/directory/filename of the back-end database. I can
do this for the front-end with this code:
Public glCurrentfe As String
Dim dbs As DAO.Database
Set dbs = CurrentDb
glCurrentfe = dbs.Name
The global variable glCurrentfe would now contain the
path/directory/filename of the front-end database. How
do I get a variable loaded with the back-end database?
I'm not interested in checking links or linking it
because it's already been linked. I just want to get the
path/directory/name of the back-end database into a
string variable.
Thanks,
Dan