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

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.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr