[AccessD] MySQL Help

Thank you to everyone that responded, and so quickly too!  I will take a look at the links and suggestions provided.  If anyone has any additional info, please do not hesitate to send it on.
 
Jeff Barrows
MCP, MCAD, MCSD
 
Outbak Technologies, LLC
Racine, WI
jeff at outbaktech.com

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Steve Conklin
Sent: Tue 10/25/2005 1:02 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] MySQL Help



I'm trying to get proficient in it as well, but was only thinking to
introduce it where the client will not have any form of MSSQL.

>anything that might help
Have you looked at Toad?
http://www.toadsoft.com/toadmysql/toad_mysql.htm  It is indispensable for
mysql.


Steve


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia
Sent: Tuesday, October 25, 2005 1:37 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MySQL Help

Because... MSDE has a governor...We plan on moving to Sql Server 2005 after
the first SP, so we will be able to use Sql Server Express in lue of mySQL
or MSDE. mySQL is licensing free as is MSDE (when you buy the right
software). I'd like to be proficient in mySQL because for certain tasks, it
may be bigger/better/faster in our environment.



On 10/25/05, Steve Conklin <developer at ultradnt.com> wrote:
>
> At the risk of starting a never-ending debate-thread, why not put the
> "minor" db's in MSDE, (especially since you have MSSQL in house, you
> can get around the lack of E-M for MSDE alone)?
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco
> Tapia
> Sent: Tuesday, October 25, 2005 12:51 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] MySQL Help
>
> mySQL is now a very robust db engine. w/ Version 5.0 they support
> triggers/sprocs (stored procedres) and of course transactions. I have
> not had a chance to load it and play with the system but you can bet I
will.
> I'm
> acctually looking forward to "Base" (Open Office desktop db) it
> supports connecting to Access, (for data/ not code nor reports). For
> me the idea of such a move is to help move some sql server databases
> to mysql because they really do not justify begin in MSSQL. I'd rather
> save those licenses for our enterprise db's
>
>
>
> On 10/25/05, Jeff Barrows <Jeff at outbaktech.com> wrote:
> >
> > Hello all,
> >
> > I am working with a company whose previous 'programmer' (and I use
> > that term VERY loosely in his case) decided that the best database
> > system was MySQL. He was using Access 2003 as a front end, importing
> > multiple text files and spreadsheets (some of them with 1 million +
> > records) into Access and MySQL.
> >
> > What I am looking for is some reference materials, books, web sites,
> > forums, anything that might help.
> >
> > Jeff Barrows
> > MCP, MCAD, MCSD
> >
> > Outbak Technologies, LLC
> > Racine, WI
> > jeff at outbaktech.com
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> --
> -Francisco
> http://pcthis.blogspot.com |PC news with out the jargon!
> http://sqlthis.blogspot.com | Tsql and More...
> --
> 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
>



--
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...
--
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