Convert Access DB to MySQL

Completado Publicado Nov 23, 2013 Pagado a la entrega
Completado Pagado a la entrega

I have on old website running on coldfusion with an Access database. Site has been shut down due to errors caused by access database. I need to convert access to MySQL, and ensure website is working properly with no errors. Here is more information from web hosting company:

As you can see from above, your site has generated 5173 errors within the past 5 days! This is affecting the performance of the ColdFusion application causing it to crash more frequently. It is URGENT that you contact us regarding this issue, and the time-frame it will take to resolve these error messages, in order to prevent service interruption.

It appears that the bulk of the error messages are in relation to connecting to an MS Access database. The best solution for this issue is to use a different database solution than MS Access. There are many technical limitations of MS Access that prevent it from being a production level database solution. While it works very well in proof-of-concept, or planning stages, it was never intended as the final step. You can find more information on the limitations of MS Access on the following article:

[url removed, login to view]

In addition, you can download the following document from Microsoft's website:

[url removed, login to view]

From page 14:

Not for Web Solutions

Access isn't designed to create Web sites. The Data Access Pages are of limited use in intranets, but not on the Internet. The underlying Jet engine is also not useful, except when the number of simultaneous users is low. Access is optimized for Windows, and not for the Web.

Converting to MS SQL or MySQL should eliminate your issue, and prevent it from re-occurring. You can find more information about converting to MySQL on the following helpful support article:

[url removed, login to view]

Administración de bases de datos MySQL Verificación de páginas web

Nº del proyecto: #5159023

Sobre el proyecto

8 propuestas Proyecto remoto Activo Nov 23, 2013

Adjudicado a:

maniya15

Hi I have gone through the requirement.. my suggestion is instead of access to mysql you can go with access to mssql.. Why am telling this because there is more query syntax is different when we compare to microsoft Más

$155 USD en 3 días
(24 comentarios)
4.9

8 freelancers están ofertando un promedio de $221 por este trabajo

bigdognec

The solution may not be merely replacing the database but the application as well to work with the new database. There are several limitations of using coldfusion itself for a production environment in this regard. Más

$263 USD en 30 días
(52 comentarios)
5.7
srinichal

I like to discuss further details about the project and deliver the same to your specifications and needs

$252 USD en 3 días
(16 comentarios)
5.7
breathhacker

Hey mate, I have 5 years of experience in database administration. I can start working on these issues right now and complete the project asap. Thanks -Akshay

$202 USD en 3 días
(6 comentarios)
5.5
tlchung

skilled mysql developer here, have done over 500+ mysql project for my clients, i can do the conversion for you, let start now.

$231 USD en 3 días
(34 comentarios)
4.5
hardikshah83

Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Micr Más

$94 USD en 3 días
(6 comentarios)
2.9