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

Just to gild an already perfect lily, this is a double-method with a bit of
explanation

http://www.pcreview.co.uk/forums/check-if-table-linked-t3748757.html


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Sunday, March 10, 2013 9:33 AM
To: accessd at databaseadvisors.com
Subject: Re: [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.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com