view links without using the link table manager

[ProgramError]

I normally display the backend link location on my switchboard. So I thought I would share this with you.

If all links are in the same table you could use a dlookup method to look for a flag = 1048576 in the msysObjects table (normally hidden). The following displays the link if it is linked by a ODBC link.
eg. =DLookUp("Connect","MSysObjects","[flags] = 1048576")

or if the links are over different databaes and different connections use the following SQL to return the results.



Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[ProgramError]

SELECT MSysObjects.Connect, MSysObjects.Database, MSysObjects.ForeignName
FROM MSysObjects
WHERE (((MSysObjects.ForeignName)<>""));

Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.