[AccessD] Access with a MySQL database

Hi Barb:

These comments are from my observations:

1. Using MySQL is slower than Access DAO when working with small to medium
sized tables and having to use an ODBC driver adds another performance hit.
The lose in performance is totally connection related.
2. MySQL's tables can exceed 2GB, still runs fast, even with huge files and
of course it is free.
3. MS SQL does not need an ODBC drive, handles huge files, runs very fast
and has an awesome set of features but can be considered expensive.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Barbara Ryan
Sent: Wednesday, October 27, 2004 11:14 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access with a MySQL database


Thanks, Marty....

I had looked at this site as well as several others on the Web.  I think
that my main question is a performance issue --- since MySQL does not use
server side cursors, is there any performance advantage over using the
existing Access back-end?

I could also use a SQL Server back-end using ODBC.  However, it is my
understanding that I would need modify code (SQL statements, queries, etc)
in the Access front end to optimize performance using SQL Server (vs. an
Access back-end).  I am not an expert in any of this my any means, so please
correct me if I've spoken heresy!

Again, some considerations are that my client currently does not own SQL
Server but is using MySQL in their web application.

Thanks,
Barb Ryan




----- Original Message -----
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, October 27, 2004 10:43 AM
Subject: Re: [AccessD] Access with a MySQL database


> Something I came across from an ASP perspective
> http://www.aspfree.com/c/a/Microsoft-Access/An-Access-Front-End-to-MySQL/
>
> Barbara Ryan wrote:
>
> >Does anyone have any experience using an Access application as a
front-end to a MySQL database back-end?  My client is interested in
converting the Access back-end to either SQL Server or MySQL.  They
currently do not own SQL Server but are using MySQL in their web
application.
> >
> >Any thoughts (advantages, limitations, etc.)?
> >
> >Thanks,
> >Barb Ryan
> >
> >
>
> --
> Marty Connelly
> Victoria, B.C.
> Canada
>
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com