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

Thanks Doug. I've got quite the collection now.

A/


On Mon, Mar 11, 2013 at 12:13 PM, Doug Murphy <dw-murphy at cox.net> wrote:

> Arthur,
>
> I got this from the Access Developer Handbook many years ago.
>
>      For Each td In CurrentDb.TableDefs
>             If Not IsNull(td.Connect) And td.Connect <> "" Then
>                 td.Connect = dsn
>                 td.RefreshLink
>            End If
>        Next
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
> Sent: Sunday, March 10, 2013 6:20 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Connect Access app to MySQL using a connection
> string
> not a DSN
>
> 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
>
> --
> 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