[AccessD] MySQL Help

If MySQL is used right it can be an excellent DB connected to Access. The
main problem that I had to deal with in the past (no current related
contracts) was that an ODBC connection was the only option. It proved quite
a bottle-neck. I believe there is now an OLE driver, somewhere, at a price
but have not research it. This combination would be excellent especially
with the latest version 5 I believe.

There are plenty articles on the internet on translating an Access MDB to
MySQL but not the other way around. Like:
http://www.kitebird.com/articles/access-migrate.html
And using an ODBC driver
http://www.washington.edu/computing/web/publishing/mysql-access.html
and there is a forum on MySQL:
http://forums.mysql.com/list.php?65,page=5

HTH
Jim
    

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff Barrows
Sent: Tuesday, October 25, 2005 9:38 AM
To: AccessD
Subject: [AccessD] MySQL Help

Hello all,
 
I am working with a company whose previous 'programmer' (and I use that term
VERY loosely in his case) decided that the best database system was MySQL.
He was using Access 2003 as a front end, importing multiple text files and
spreadsheets (some of them with 1 million + records) into Access and MySQL.
 
What I am looking for is some reference materials, books, web sites, forums,
anything that might help.  
 
Jeff Barrows
MCP, MCAD, MCSD
 
Outbak Technologies, LLC
Racine, WI
jeff at outbaktech.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com