Greg Worthey
greg at worthey.com
Mon Jul 9 18:49:20 CDT 2007
Rocky, I've worked with mysql. Just use myodbc driver to connect to backend, like you would link to ms sql server. Pretty easy to set up. To make it switchable, I haven't tried that, but I think that wouldn't be too hard. Greg Worthey Worthey Solutions www.worthey.com -----Original Message----- Message: 17 Date: Mon, 9 Jul 2007 08:57:54 -0700 From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com> Subject: [AccessD] Converting to MySql To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Message-ID: <003201c7c241$e9619de0$0301a8c0 at HAL9005> Content-Type: text/plain; charset="US-ASCII" 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 ------------------------------ Message: 18 Date: Mon, 9 Jul 2007 09:07:48 -0700 From: "Charlotte Foust" <cfoust at infostatsystems.com> Subject: Re: [AccessD] Syntax for loading a specific version of Access To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <F55048AF7E974F429BB24597D7355EEA4BA2D6 at INFOSERVER04.infostat.local> Content-Type: text/plain; charset="us-ascii" Then I haven't a clue. I use the Send To shortcuts on my machines, so I can specify the precise version of Access to use. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Monday, July 09, 2007 8:05 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Syntax for loading a specific version of Access Open with. Things keep screwing up when I run the app on my box, which has every version of Access loaded since O97, but the default seems to be to load the latest. I want to tell the shortcut to load A2K and then the specific MDB|ADP in question. A. On 7/9/07, Charlotte Foust <cfoust at infostatsystems.com> wrote: > > Are you talking about a "send to" or "open with" shortcut, Arthur? > > Charlotte Foust > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ------------------------------ Message: 19 Date: Mon, 9 Jul 2007 12:16:01 -0400 From: "Arthur Fuller" <fuller.artful at gmail.com> Subject: Re: [AccessD] Syntax for loading a specific version of Access To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <29f585dd0707090916y50b52de2t4182ec63e4541912 at mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed That might do, Charlotte. Tell me how to do that and I'll try it out. A. On 7/9/07, Charlotte Foust <cfoust at infostatsystems.com> wrote: > > Then I haven't a clue. I use the Send To shortcuts on my machines, so I > can specify the precise version of Access to use. > > Charlotte Foust > ------------------------------ Message: 20 Date: Mon, 9 Jul 2007 09:47:58 -0700 From: "Charlotte Foust" <cfoust at infostatsystems.com> Subject: Re: [AccessD] Syntax for loading a specific version of Access To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <F55048AF7E974F429BB24597D7355EEA4BA2DF at INFOSERVER04.infostat.local> Content-Type: text/plain; charset="us-ascii" Unless someone else has it at their fingertips, I'll check my laptop tonight. I never bothered to put it on this office machine, since I'm working with a single version of Access here. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Monday, July 09, 2007 9:16 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Syntax for loading a specific version of Access That might do, Charlotte. Tell me how to do that and I'll try it out. A. On 7/9/07, Charlotte Foust <cfoust at infostatsystems.com> wrote: > > Then I haven't a clue. I use the Send To shortcuts on my machines, so > I can specify the precise version of Access to use. > > Charlotte Foust > -- 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 End of AccessD Digest, Vol 53, Issue 15 ***************************************