That has not been my experience, in fact my experience has been completely the opposite. As my first test case I ported the Northwind sample database to MySQL. I had to make a few changes here and there, most notably to some queries, but also including (and I forgot to mention this in my previous reply on this subject) adding a column of type TimeStamp to every table in the database. This is necessary so that you can read auto-increment values.
Next, I took my current app, with about 94 tables, and ported it. The production app is in MS SQL 2000, but I wanted to port it because I wanted a proof-of-concept to show management. The absence of sprocs was a big problem (come on, 4.1 :-) but I worked around it. No one but me and a few testers is using this version. The production app remains in MS SQL. Finally, I took my killer-database, whose tables number 400+. Fortunately, with dbScripter in hand I didn't have to create say 1000 indexes by hand! It ported well and my Access front end talks blissfully to it. The MySQL part resides on a P233 running Mandrake, set up for InnoDB. This may simply be high praise for MyODBC, but my Access app has no difficulty at all talking to the database. Arthur ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Arthur Fuller" <[EMAIL PROTECTED]> Sent: Wednesday, August 28, 2002 1:57 PM Subject: [Fwd: RE: MS Access and mySQL] > wodya think? > > > -------- Original Message -------- > From: "Nicholas Stuart" <[EMAIL PROTECTED]> > Subject: RE: MS Access and mySQL > To: <[EMAIL PROTECTED]> > CC: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > > 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 --------------------------------------------------------------------- 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
