Currently my organization is undergoing restructuring of existing databases. Previously, certain applications were made using FoxPro and other applications were using MS Access. What i am planning to do is migrate everything to mysql, using it as backend. Now my problem is regarding the Front End? Which application to use? Visual Basic or MS Access? What would be more advantageous in terms of performance and future support and consume less time for modifications? I tried to search online but really could not find anything to justify any particular choice. Can anybody plz suggest some idea here or give some reference, which will help me finalize the decision regarding the appropriate front end.
Thank u all in advance for all your time and efforts.
You can choose VB as front end. It is quite easy. If u want to get help on connection then go for VBMySQL forum. You will get the connection strings and help how to connect by ODBC driver. But it may work slow. I don't know why. Because I have done samething. Besides it is working fine but the connection very slow. It may be becuase my database is not indexed. I will try for that and later come to u.
Thanks for your reply. I dont exactly understand when u say connectivity between MS Access and mysql. I presume, u r talking about how will I connect mysql and MS Access (i may be wrong here), that will be through ODBC. Currently we have a FoxPro DB going on, but we are going to scrap it because foxpro just cant handle the data requirements here. Hence mysql will be backend, which is, I have heard, a reasonably good database. U said about mixing MS Access and mysql, wont that make things complicated? How easy will it be to change data or do modifications? Currently here we have a LAN of 100/100Mbps, so n/w connectivity would not be a prob i guess. Client machines are somewhat slower, so I want to keep processing on client m/cs as minimal as possible and let the server, where mysql will be residing, do the job of querying and sending the data across.