A Amir Jun 28, 2004 #1 go to Tools -> Add-Ins ->Linked Table Manager -----Original Message----- Is it possible to obtain the path that a table is linked Click to expand... to in the back end? How would I do this? Is it a property of the table?
go to Tools -> Add-Ins ->Linked Table Manager -----Original Message----- Is it possible to obtain the path that a table is linked Click to expand... to in the back end? How would I do this? Is it a property of the table?
M Marshall Barton Jun 28, 2004 #2 Is it possible to obtain the path that a table is linked to in the back end? How would I do this? Is it a property of the table? Click to expand... It's contained in the table's TableDef.Connect property strConnect = CurrentDb.TableDefs!nameoftable.Connect If the table it's linked to is in a Jet (Access) MDB file, then the path statrs in the 11th character: strPath = Mid(strConnect, 11) If it's a different database engine then parse it out using the InStr function. It's be right after Database= and before the next semicolon.
Is it possible to obtain the path that a table is linked to in the back end? How would I do this? Is it a property of the table? Click to expand... It's contained in the table's TableDef.Connect property strConnect = CurrentDb.TableDefs!nameoftable.Connect If the table it's linked to is in a Jet (Access) MDB file, then the path statrs in the 11th character: strPath = Mid(strConnect, 11) If it's a different database engine then parse it out using the InStr function. It's be right after Database= and before the next semicolon.
