Steve Goodhall
steve at goodhall.info
Fri Aug 6 09:35:21 CDT 2010
BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px; }Are you currently using an Access BE database or some other RDBMS? I have just started playing with MySQL but I have done several conversions to MSSQL. You will need to set up an ODBC connection to the MySQL database and link the tables. There are probably some subtle difference in the SQL so you may need to do a lot of testing. Regards, Steve Goodhall, MSCS, PMP 248-505-5204 On Fri 06/08/10 10:22 AM , "Rocky Smolin" rockysmolin at bchacc.com sent: Deal List: I have a client with a rather large application who is considering upgrading the back end to MySql. Object: ~100 forms ~150 queries ~75 reports Lots of code modules with many lines and lots of CBF. The app uses bound forms and lots of DAO. Question is, of course, what is involved in converting this front end to work with a MySQL back end? MTIA, Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com ; www.bchacc.com ; -- AccessD mailing list AccessD at databaseadvisors.com [1] http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Links: ------ [1] mailto:AccessD at databaseadvisors.com