Hi Arthur, Which version of MySQL / MyODBC are you using? I tried building an app with an Acc2000 frontend and a MySQL backend using MyODBC and kept running into a problem where the record being edited would become 'locked' and wouldn't allow me to update (from memory it was something along the lines of the table reporting it was busy performing another action or similar).
This frustrated me enough that I finally gave it away and now use SQL Server as my 'big backend.' Regards, M. -----Original Message----- From: Arthur Fuller [mailto:[EMAIL PROTECTED]] Sent: Monday, 30 September 2002 12:12 AM To: David Lloyd; Adam Parker Cc: [EMAIL PROTECTED] Subject: Re: MySQL as a desktop DB I don't think Access is crap at all. In fact I think it's a) the best RAD front end going for SQL Server and perhaps for MySQL too. I use Access 2000 and 2002 + MyODBC to create front ends to MySQL databases and the combination works great. In less than one morning I successfully ported the Northwind sample application to MyOBC+MySQL. I had to fix a couple of queries that wouldn't translate, but other than that it worked like a charm. And one of the best reasons to go with such a combination is that Access can save named queries, which can then be combined. For example: qryProductsList: SELECT products.ProductID, products.ProductName, products.UnitPrice, products.SupplierID FROM products ORDER BY products.ProductName; qrySuppliersList: SELECT suppliers.SupplierID, suppliers.CompanyName FROM suppliers ORDER BY suppliers.CompanyName; qryCombinedProductsAndSuppliersList: SELECT qryProductsList.ProductName, qryProductsList.UnitPrice, qrySuppliersList.CompanyName FROM qrySuppliersList INNER JOIN qryProductsList ON qrySuppliersList.SupplierID = qryProductsList.SupplierID; MySQL by itself doesn't provide this kind of capability. I find it enormously valuable. Just my $.02. Arthur ----- Original Message ----- From: "David Lloyd" <[EMAIL PROTECTED]> To: "Adam Parker" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 8:37 PM Subject: Re: MySQL as a desktop DB > > Adam, > > > Obviously MySQL would have advantages if I intended to use it as a server > > database with concurrent users. But is it faster than Access in the > > single-user environment, when dealing with large databases? > > MySQL in a single user environment is a pain in the arse because of its > lack of an Access Like front end that is actually useful and featureful > (Access is crap, but it's a better database frontend than currently > exists). > > (mysql, query) > > DSL > -- > I reniad lin ne mor, nuithannen > In gwidh ristennin, i fae narchannen > I lach Anor ed ardhon gwannen > (Soundtrack LOTR - and it's not LATIN) > > --------------------------------------------------------------------- > 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