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:[EMAIL PROTECTED]] > Sent: Wednesday, August 28, 2002 12:40 AM > To: [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
