Darryl Collins
darryl at whittleconsulting.com.au
Mon Oct 14 17:42:22 CDT 2013
Access 2010 will hook into MySQL with no issues. I have done that before. Was easy enough to set up and get working. Cheers Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Tuesday, 15 October 2013 12:50 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Modifying Replicated Database Using Access 2010 I have done several apps using Access as a front end and MySQL as a back end. It's pretty much dead simple to set up, and I also found a utility called Access to MySQL that made it absolutely effortless to port the data, automatically handling the various data-type conversions. Once the data was moved all that was required was to link to the new BE using ODBC. Best of all, database size was no longer an issue at all. Plus I still got to use MZ-Tools. I've done this sort of conversion with both Access XP and 2007 without any problems. I haven't tried it with any more recent versions, but I see no need to. Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com