VB MSAccess to Linux MySQL

[lordcenon]

I have this VB program which uses MS Access as database under Win XP, we intend to use a Linux SQL server for the database instead, without changing any much code and using an SQL database, how do i go about this? Is this possible? I can use some advice. Many thanks to all.

[sashi]

I have this VB program which uses MS Access as database under Win XP, we intend to use a Linux SQL server for the database instead, without changing any much code and using an SQL database, how do i go about this? Is this possible? I can use some advice. Many thanks to all.

Hi there,

Code modification is a must, the database connection string need to be changed in order to be able to access MySQL database. Some of the MS-Access datatypes are not supported in MYSQL database.

Kindly refer to below attached link for further reading & understanding, hope it helps. Good luck & take care.

http://www.freevbcode.com/ShowCode.asp?ID=6600

[lordcenon]

Hi there,

Code modification is a must, the database connection string need to be changed in order to be able to access MySQL database. Some of the MS-Access datatypes are not supported in MYSQL database.

Kindly refer to below attached link for further reading & understanding, hope it helps. Good luck & take care.

http://www.freevbcode.com/ShowCode.asp?ID=6600

Many thanks, i will chk on it.Best rgds.

[sashi]

Many thanks, i will chk on it.Best rgds.

Hi there,

Good luck & take care.

[alpnz]

From your first message, I am assuming you are keeping the XP workstations, running an Access frontend, and Using the Linux MySQL as the server, which is a reasonably solid platform..
They work well, I have implemented a couple of solutions along this scenario. As per other replies, Access can get a bit tichy about some of the Field types and settings in MySQL. Best to invest in a cheap converter, there is a very good product out there from Intelligent Converters which will convert your Access Tables onto a MySQL server. There may be a little glitch or two, in terms of field types, but very usable for basic KISS built databases. PremiumSoft MySQL Studio is worth adding to your Admin Box, which enable you to Mine data for various Management requests.
Of course there are a number of Access Forms to PHP converters, which I have not explored all that much, preferring to put something simple together on Access. By the way there is a Database product from KOffice, which tries to look and behave just like Access. From memory it started out being called KIM or something. Anyhoooo good luck, hope these suggestions might help

John S

[sashi]

From your first message, I am assuming you are keeping the XP workstations, running an Access frontend, and Using the Linux MySQL as the server, which is a reasonably solid platform..
They work well, I have implemented a couple of solutions along this scenario. As per other replies, Access can get a bit tichy about some of the Field types and settings in MySQL. Best to invest in a cheap converter, there is a very good product out there from Intelligent Converters which will convert your Access Tables onto a MySQL server. There may be a little glitch or two, in terms of field types, but very usable for basic KISS built databases. PremiumSoft MySQL Studio is worth adding to your Admin Box, which enable you to Mine data for various Management requests.
Of course there are a number of Access Forms to PHP converters, which I have not explored all that much, preferring to put something simple together on Access. By the way there is a Database product from KOffice, which tries to look and behave just like Access. From memory it started out being called KIM or something. Anyhoooo good luck, hope these suggestions might help

John S

Hi there,

Thank you for the info provided regarding DB converters :) Good luck & Take care.