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
