MsAccess to MySql.

Hello all,

At present I am looking to upgrade my current MsAccess 2000 project with 9 relational databases to (one or multiple) MySql database. Is there a way to use some sort of tool that will automatically upgrade the database?

The "problem" I have at present is that in my Access Databases I use semi stored procedures that I call from ASP pages. The reason why I use the term semi sp is because in my understanding MsAccess doesn't pre process stored queries.

So actually I have the following questions related to MySql:
- Can MySql handle stored procedures
- Is there a way to upsize the MsAccess to MySql
- If you can upsize, will it take all stored "views" procedures in the MsAcces database and pass it to MySql.
- What is the max amount of concurrent users possible with MySql. I know SQL 2000 can handle 40.000 users, MsAccess should be able to handle 255.... (This is also the reason why I want to upgrade the MsAccess to MySql..)

In the past I tried to upgrade the database using the upsize wizard to Ms SQL2000 all update and insert queries were garbled. Due to the high amount of stored procedures I really want to do this automatic..

Thanx in advance for any answers or thoughts on this..

Werner.

Hey man, I am just looking for that, I have a lot of data in Access XP and I want to shift all the records to my tables in MySQL. Is there any tool through which I can shift the data from Access to MySQL. Approximately I have 50,000 records in different tables.

Secondly what is the alternate for Stored Procedures in MySQL??

Any help is welcomed

Try MyAccess. It is an AddIn for MS Access 97/2000 which allows you to manage MySQL databases from within Access.

Create/Modify Tables, Execute Queries against MySQL. Synchronize tables between Access and MySQL
Import/Export tables from Access to MySQL and vice versa

URL

Thanx for the usefull info.

Will get to that site at once.

Thanks

I have found another solution of shifting records from Access to MySQL. Using ASP I have created two recordsets one of Access and another of MySQL. After that I started reading the records from Access and using Insert query inserted the records in MySQL. And voila all the records were shifted to MySQL.

Now is it possible to create stored procedures in MySQL?

There are several tools available on google to convert database like Access to MySQL databases, you can easily search for it, i use convert db for such aim.

Find Here : www(.)convert-db(.)com

Hello Expert11,

Thank you for replying on the post. It has been over 7 years and not applicable anymore for me. But I hope someone else with the same query will benefit from this information.

My solution in the past was to go get Sql Server express edition. This can import msaccess without problems.