I have to concur, MS Access with ODBC linked tables is not a good solution when those tables contain large amounts of data. I had queries run for hours and then come up with a simple "ODBC Failed" message at the end of it. Maybe Access has improved though.....
Tod Harter wrote: > Watch out with using the Jet database engine this way. MS Access tries to > keep linked external table views in sync, which means that with large tables > and several PCs running Access linked to MySQL over ODBC driver it will bring > your network to its knees. The Jet engine will constantly be scanning tables > on the database server, generating GIGANTIC amounts of traffic. I've seen > 100mb ethernet completely swamped by just 3 or 4 clients. There are probably > work-arounds for that, but you should definitely test first, MS Access is a > very badly behaved piece of KAKA. > > On Monday 22 April 2002 07:29, Hathaway, Scott L wrote: > > I would not look at front ends to mySQL. Instead, I would let them keep > > using access to do this and link them to the mySQL database or get an SQL > > query tool that allows for graphical queries. > > > > Scott > > > > -----Original Message----- > > From: Pierre du Parte [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, April 20, 2002 3:06 AM > > Cc: MySQL > > Subject: GUI for mySQL > > > > > > I am gradually winning the war in promoting opensource to a number of my > > key customers. Notably a couple have made the move to OpenOffice.org, > > albeit on Windows. I am currently re-writing a key application to use > > mySQl (previously Access), so in all I'm pleased. > > > > However, the head bean counter in one office tackled me on this - "In > > Access I can quickly create queries and export the results in all manner > > of ways. What do I do if we let you talk us into mySql?" > > > > Where indeed? Are there any nice, user friendly GUI available for mySQL > > ad-hoc query and report design? > > > > Thanks > > --------------------------------------------------------------------- > 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
