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

Doug Murphy dw-murphy at cox.net
Mon Mar 11 11:13:16 CDT 2013


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



More information about the AccessD mailing list