MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Nicholas Stuart Date:August 28 2002 3:19pm
Subject:RE: MS Access and mySQL
View as plain text  
I would strongly urg you not to use Access as the front end. The biggest
problem is that the Jet Engine/Access backend is pretty much completly
different then MySQL and you will run into problems with table structure
and the like. Also, using access as the front end has been extremly slow
when ever I tried it.
You will however need to download the MyODBC driver if you wish to access
MySQL through VB.

-Nick

>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Jonathan,
>
> If you are going to be completely converting the Access db to MySQL,
> and just using Access as the frontend, you will need to download
> MyODBC:
>
> http://www.mysql.com/downloads/api-myodbc.html
>
> You can download either the stable or development release. There is
> also a FAQ that will answer your questions there about how to setup
> almost exactly what you are referring to.
>
> http://www.mysql.com/products/myodbc/faq_toc.html
>
> This FAQ is for the development release (3.51.03) but can also be
> used for the stable release (2.50.xx). I recently had to do the same
> thing with a Paradox database for a client, and have had relatively
> few issues following the documentation. After downloading and
> installing MyODBC you will be able to export the database directly to
> your Linux MySQL, however you will lose your table structures for the
> most part and will have to do some ALTER TABLE statements to put your
> keys back and the majority of your fields set to their proper type.
>
> HTH,
> Bryant Hester
> Juxtapose, inc.
>
> - -----Original Message-----
> From: Jonathan Coleman [mailto:jonathanrcoleman@stripped]
> Sent: Wednesday, August 28, 2002 12:40 AM
> To: mysql@stripped
> Subject: MS Access and mySQL
>
>
> Hi.
>
> I have a situation where a church I am doing some volunteer work for
> has a MS Access (office 97) database running on NT.  They are
> (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL
> installed (and I can upgrade it etc..)
>
> My job therefore is to
>
> a) port MS Access data and queries to mySQL database
>
> b) use the MS Access forms to access the data and queries through
> ODBC.
>
> Is there anyone who can point me in the right direction, either to
> where the searchable discussion archives are, OR even better, someone
> who has gone through this before?
>
> Cheers
> Jon
>
> http://digital.yahoo.com.au - Yahoo! Digital How To
> - - Get the best out of your PC!
>
> - ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread118159@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-bhester=juxtaposeinc.com@stripped>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBPWzH6UlWu7/HFp4nEQJOGwCgr5af7wIi1AcbpP1rih/vABg/zb8An13w
> 4Tm8I6eugdNnVhLYZ+CcTYq2
> =Z0ov
> -----END PGP SIGNATURE-----
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread118202@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-nick=newtsplace.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



Thread
MS Access and mySQLJonathan Coleman28 Aug
  • RE: MS Access and mySQLBryant Hester28 Aug
    • RE: MS Access and mySQLNicholas Stuart28 Aug
      • RE: MS Access and mySQLRoger Davis28 Aug
        • RE: MS Access and mySQLNicholas Stuart28 Aug
        • Re: MS Access and mySQLGelu Gogancea28 Aug
  • mysql password ( )Mark Stringham28 Aug
    • Re: mysql password ( )Leonardo Javier BelĂ©n28 Aug
    • Re: mysql password ( )Daniel Kiss29 Aug
  • Re: mysql password ( )Randy Johnson29 Aug
Re: MS Access and mySQLNicholas Stuart28 Aug
  • RE: MS Access and mySQLMary Stickney28 Aug
    • Re: MS Access and mySQLMark Matthews28 Aug
      • RE: MS Access and mySQLMary Stickney28 Aug
        • Re: RE: MS Access and mySQLEgor Egorov29 Aug
Re: MS Access and mySQLArthur Fuller28 Aug
  • Re: MS Access and mySQLNicholas Stuart29 Aug
Re: mysql password ( )Daniel Kiss29 Aug