F Kay Kendrick
fkkendrick at cox.net
Tue Jul 10 14:15:24 CDT 2007
Rocky, >From http://www.kitebird.com/articles/access-migrate.html#TOC_2: ...if you install the MySQL Connector/ODBC driver (formerly known as MyODBC), Access can make ODBC connections to MySQL servers over the network. You can still use the contents of your tables through Access, but the tables themselves are hosted by the MySQL server. The MySQL Connector/ODBC driver can be downloaded from http://www.mysql.com/products/connector/odbc/. There is also a migration toolkit available from http://www.mysql.com/products/tools/migration-toolkit/. HTH, Kay -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Monday, July 09, 2007 6:25 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] FW: [AccessD] Converting to MySql Copied from the AccessD list. I think this question is more appropriate here. Rocky Rocky Smolin at Beach Access Software wrote: > Dear List: > > I have a request to make my manufacturing package compatible with > MySql. I use some bound forms, and a lot of DAO. The app is split > FE/BE with linked tables pointing to the BE. I also allow the user to > select the BE they want so they can run multiple BEs if desired. > > What would be involved in doing this? Would it be enough of a rewrite > that it would require a separate product? Or can the current product > be made 'switchable' between an Access BE and a MySql BE? MTIA, Rocky _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com