[AccessD] Connect Access app to MySQL using a connection string not a DSN

Hi Arthur

You can run this Query for a list of the linked tables:

SELECT 
  MSysObjects.Name AS LocalName, 
  MSysObjects.ForeignName AS SourceName
FROM 
  MSysObjects
WHERE 
  MSysObjects.Type = 6;

/gustav


>>> fuller.artful at gmail.com 10-03-13 14:20 >>>
This thread reminds of another question I meant to ask. When walking the
tabledefs collection, how does one determine whether a table is linked or
local? I want to generate a list of each. There are something like 300
tables in the app, only about a dozen of which are local. But no special
naming convention was used to identify which are local, and walking the
list by hand is as exciting as watching paint dry.

A.