Help: Access to MYSql

**vaspot** · 05-18-2005, 11:05 AM

Does anyone know how to change the access databate to MySQl?? if so hit me up thanks

**chrishirst** · 05-18-2005, 04:21 PM

would you like to explain a little more.

do you want to transfer data?
change an app to use MySQL?

or what ?

**vaspot** · 05-19-2005, 09:23 AM

I want to change the whole access database to MYSQL, so my site would be pointing to MYSQL instead of the original access database.

**chrishirst** · 05-19-2005, 09:28 AM

Providing that the queries use ANSII SQL and not the MS proprietary T-SQL, It's simply a case of exporting the access database tables to MySQL and setting the connection parameters

**numbenator** · 05-20-2005, 11:17 AM

just picked this thread up by mistake but you provide the answer to a question would of asked soon.
cheers Chris.

**vaspot** · 05-23-2005, 09:14 AM

Thanks

**Uche** · 05-24-2005, 07:55 PM

i guess i know that.. but have really 4gotten how.. the best thing is to do aall ur DB work in MySQL