ms access to MYSQL

[manjunatha]

i have developed a web site in ASP with backend msaccess.
now i have to shift existing data to MYSQL Database, and
use MYSQL database instead of msAccess, what all i need to
DO.. i mean to say how to convert MS Access DAtabase to
MYSQL Database. what kind of changes required in ASP
programing.


please help me

thanks in advance

[Jeff Cochran]

On Tue, 22 Jul 2003 11:03:31 -0700, "manjunatha"
<mattikoppa@yahoo.com> wrote:

>i have developed a web site in ASP with backend msaccess.
>now i have to shift existing data to MYSQL Database, and
>use MYSQL database instead of msAccess, what all i need to
>DO.. i mean to say how to convert MS Access DAtabase to
>MYSQL Database. what kind of changes required in ASP
>programing.

Google "convert access to mysql" for the database conversion. As for
the ASP code, it depends on what your code is. The only thing that';s
normally different might be SQL syntax if anything, but it really
depends on the code you wrote.

Jeff