Jim Lawrence
accessd at shaw.ca
Thu Oct 22 13:53:31 CDT 2009
Hi Mark: If you are setting up MySQL you should start thinking of using SPs. MySQL version 5 has this feature and pass-through queries in MSAccess, especially SELECT type queries are soooo slowwwwww. Check out the following: http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html HTH Jim -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Mark Breen Sent: Thursday, October 22, 2009 10:54 AM To: Discussion of Hardware and Software issues; Discussion concerning Visual Basic and related programming issues. Subject: [dba-VB] Can anyone suggest a Windows good client for mySQL Hello All, I have to assist a friend tomorrow in connecting to a mySQL database and starting to build some queries. I intend to show him the differences between writing queries in MS Access when linked to mySQL, and using pass-through queries within Access. I will also be explaining the benefits of having a few views created also. What I am looking for is a Windows based GUI tool that would connect to mySQL and allow him to build queries with click and drag like SSMS or Access does. This evening I have downloaded and installed two tools, one is the default GUI as shipped by mySQL and another is named EnginSite. Both seem, on initial looking anyway, to to allow me to drag a few fields from a table, but they do not seems to allow me to drag two or three tables and for the joins to be done in the GUI. Would anyone have any suggestions? TIA for your time, Mark _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com