MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Bryant Hester Date:August 28 2002 12:54pm
Subject:RE: MS Access and mySQL
View as plain text  
 
-----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-----

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