Database name of the database that contains the tables to which my tables are liked (1 Viewer)

[pacctono]

Hello, people!

I have been looking into google and I have not found it.

I have an access database file that I am using as backend with the main (or shared) tables and the local one as frontend. In my local database file, I link the local tables to the tables in the server. If I want to know the whole name of my local file, I write "currentdb.name". Does any one know how to get the whole path of the access database in the server???

 

[theDBguy]

Try checking the Connect property of the linked table?

 

[isladogs]

For the linked database info, look at the Connect and Database columns in the MSysObjects system table

 

[pacctono]

Try checking the Connect property of the linked table?

Thanks a lot! Muchisimas gracias!

 

[theDBguy]

Thanks a lot! Muchisimas gracias!

De nada