Currentdb.name okay to get name of front-end. How does one get the name of the back-end?
Currentdb.name okay to get name of front-end. How does one get the name of the back-end?
I use this function to get the path name from the connection string,
I use a linked table (pick yours, mine is tAlpha) , an external linked table to determine the path:
Code:Public Function getBeDbFromLink() Dim vLink vLink = CurrentDb.TableDefs("tAlpha").Connect If vLink = "" Then getBeDbFromLink = CurrentDb.Name Else getBeDbFromLink = Mid(vLink, 11) End If End Function
if all your tables are linked to the same BE you could use
dlookup("Database","MsysObjects","[Type]=6")
Thanks for the suggestions guys. With the app of interest, all the tables are in a single backend so the dlookup will work great.
Bill