If an Access db is split with the back end tables located on a remote
server;  is there a way that I can locate the directory where the back
files are located on the remote server.

You don't say which version of Access you are using but assuming that Either
it is Access 2K or that you otherwise can make a reference to "Microsoft ADO
Ext. 2.6 for DDL and Security".

In either case, ensure that this reference is checked.

The following function will return your Full Backend path:


Function FindBackEndPath() As String

    Dim cat As ADOX.Catalog
    Dim strTableName As String

    strTableName = "tblChannels" 'The name of one of your linked tables here

    Set cat = New ADOX.Catalog
    Set cat.ActiveConnection = CurrentProject.Connection

    FindBackEndPath = cat.Tables(strTableName).Properties("Jet OLEDB:Link
Datasource")

    Set cat = Nothing

End Function



ALTERNATIVELY if you are using DAO then he following function will return
your Full Backend path:

Function FindBackEndPathDAO() As String

    Dim dbs As DAO.Database
    Dim strTableName As String

    strTableName = "tblChannels" 'The name of one of your linked tables here

    Set dbs = CurrentDb()

    FindBackEndPathDAO = dbs.TableDefs(strTableName).Connect
    FindBackEndPathDAO = Right$(FindBackEndPathDAO,
Len(FindBackEndPathDAO) - 10)

    Set dbs = Nothing

End Function

BTW, the DAO function is faster.


Hope this helps.

Ian Ashton


-----Original Message-----
From: Howard Stone [mailto:ququmber@h...]
Sent: Friday, March 29, 2002 10:45 AM
To: Access
Subject: [access] locate back end files


If an Access db is split with the back end tables located on a remote
server;  is there a way that I can locate the directory where the back
files are located on the remote server.

--0-1658912979-1017410943=:26963
Content-Type: text/plain; charset=us-ascii


 In the database window go to Tools, Addins, Linked Table Manager. 

This is where you can see the path to linked tables and their path.
 
  Howard Stone <ququmber@h...> wrote: If an Access db is split with the back end tables located on a remote
server; is there a way that I can locate the directory where the back
files are located on the remote server.

Lonnie Johnson 
ProDev, Builders of MS Access Databases
http://www.galaxymall.com/software/PRODEV 




---------------------------------
Do You Yahoo!?
Yahoo! Greetings - send greetings for Easter,  Passover