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

Hi Arthur

That is:

SELECT 
  MSysObjects.Name AS LocalName
FROM 
  MSysObjects
WHERE 
  MSysObjects.Type = 1 AND MSysObjects.Flags = 0;

/gustav


>>> fuller.artful at gmail.com 10-03-13 14:41 >>>
Thanks, Gustav. And just out of curiosity, what is the Type of a local
table?

A.


On Sun, Mar 10, 2013 at 9:32 AM, Gustav Brock <Gustav at cactus.dk> wrote:

> 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.