Convert to MySQL

[Guest]

I have an application in ACCESS to be converted to MySQL. Need help with the
following basic questions:

1. How much data can MySQL handle? People said like 10-100million
records/hundreds MegaBytes per table. Does it have limitation on overall
Database capacity?
2. The existing ACCESS DB is already very huge and complex, and it is
writeen in VBA. If I only convert the tables to MySQL and keep the link
repationship from Access to MySQL, do I have to change VBA code?
3. Which way is faster, executing through linked table in ACCESS from MySQL,
or sending a command to a stored procesdure in MyQL without linking table in
Access?

Thank you very much!

Shirley

 

[Dan Artuso]

Hi Shirley,
For MySql specific questions, look on the web site.

The only thing you *can* convert to MySql is the tables.
MySql is simply a database, it has no development environment.
It requires some sort of front end for data access.

So keep on using Access for that end of things.
There's a shareware tool called MyAccess that's available
from the MySql web site that would probably help you out.