I have an MS Access database that I want to convert to MySQL and post on our website. The database is not interactive, but must be searchable on up to the first five characters in the product name. An interactive search that begins displaying possible matches as characters are typed would be awesome.
The Access database has more fields than we will be displaying. At this time the displayed database will have 5 fields: product name, dosage, price per dose, pharmacy, country. The database will have several thousand records and the user must be able to scroll through the results.
The ability to easily maintain the database and post current information to the website is a must. If it is an automated process all the better.
I am open to recommendations on the best way to accomplish this task although an expedited result is necessary at this time.
