Question about upsizing to MySQL

[4281967]

I have an application that uses linked tables. The front-end has several queries, macros, modules, etc. If I upsize the data to MySQL, and relink the tables in the front-end application using an ODBC connection, is it safe to assume that the (access) front-end will still function as before?

I originally thought I may be upsizing to SQL server but it is cost prohibitive at this time.

Any hints, tips, or suggestions?

 

[JoeAtWork]

I can tell you only from my experience with upsizing to SQL Server, I have never done it to MySQL.

I have found that usually about 95% works fine, but there are areas here and there that needed to be fixed or re-optimized. It depends how simple/complex your database is, and how well designed it was to begin with.

One thing with SQL Server, if you have a form that you need to be able to update you must include the primary key in the query.

Once you relink to MySQL, you will need to test each of your forms and reports to make sure they still work. You will likely find a few things that need to be changed.