Arthur Fuller
fuller.artful at gmail.com
Sat Feb 23 15:34:37 CST 2013
You got it, Jim! I've been having fun converting several Access apps to use MySQL as the BE instead. It's wonderful how effortless it is. There's a cool utility called "MS Access to MySQL" that will convert an Access database to a MySQL database in a few clicks, and it's got some options that let you do things like convert yes/no values to 0 and 1 instead of 0 and -1. Then I create a new Access FE and set up a new ODBC connection to the new MySQL database. Then I import all the forms, queries, modules and reports. Presto, it's done in a very few minutes (mileage depending on table sizes of course). (I'm doing this in prep for a gig involving Access+MySQL.) On Sat, Feb 23, 2013 at 3:41 PM, Jim Lawrence <accessd at shaw.ca> wrote: > Hi Arthur: > > Just a note; could you please leave some data from the previous post in the > thread as with no data available there is sometimes no way to guess what > your current post is referring to...this is not a forum type list and our > message space is definitely not that limited. > > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller > Sent: Saturday, February 23, 2013 12:17 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Always on Top Form? > > That did it. Beautiful! Until now, I never had the need to do that. I like > it. > > 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