[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