Currently the organization I work for uses an access database to store customer information. We are interested in using a online shopping cart. (for some stock products) I've tested oscommerce, to implement on the current website. The shopping cart uses MySQL, should I link up the mysql database with our current access database and have it synchronize? (at a certain time during the day) (I've tested using the odbc mysql driver)
With the mysql information linked up to the access database I can then be able to create forms to show the customer information? Does mysql have a program that can create forms? I'm new to this so please bear with me.