Can MySQL be embedded into a VB6 program? I have a program which uses Access as the db and am finishing a client-server version using MySQL. I would like to be able to use the same program for each one by using MySQL for the stand-alone version. The db would have to be completely transparent to the user. I would like the user to be able to migrate the database to a server and use the client-server version with minimum difficulty.
This app is for volunteers in a charity to use. There is no guarantee that anyone has any computer expertise, certainly not db administrator or programmer capability.