To find out where Table1 is getting its data from, press Ctrl+G to open the
Immediate Window, and enter:
? CurrentDb.TableDefs("Table1").Connect
If it returns a zero-length string, it is a local table (not a linked
table.) If it is a linked table, the string tells you where the source
database is.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Leslie Isaacs" <(E-Mail Removed)> wrote in message
news:%23kXkp$(E-Mail Removed)...
> Hello Allen
>
> Thanks for your reply.
>
> Please excuse my ignorance, but how do I use the
> "CurrentDb.TableDefs("MyLinkedTable").Connect" expression that you have
> given me? Do I set this as a column in a query based on the table, or as
> the OnClick event of a button on a form, or is it something completely
> different. I realise that my question indicates a greater ignorance that
> you may have expected, but we've all got to start somewhere!
>
> "Allen Browne" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> The path is in the Connect property of the TableDef, e.g.:
>> CurrentDb.TableDefs("MyLinkedTable").Connect
>>
>> If you can open the table in design view, Access shows this in the
>> Description of the table (in the Properties box.)
>>
>> "Ruth Isaacs" <(E-Mail Removed)> wrote in message
>> news:%23mhI$(E-Mail Removed)...
>>> Hello All
>>>
>>> How can I find out the pathname and filename of the mdb that has the
>>> linked
>>> tables in my frontend mdb? I have 'inherited' a situation (honestly!)
>>> where
>>> I have an access97 frontend with lots of linked tables - which I suspect
>>> are
>>> not all in the same backend. I'm sure there must be a way of getting at
>>> the
>>> pathname and filename for a particular table (right-click and properties
>>> would have been too obvious!) but cannot see how.
>>>
>>> NB Linked Table Manager is not installed and I do not have an A97 CD.
Similar Threads
