I might have asked that wrong. I have a friend that has a inventory management system for his small company which lists about 1000 products. His whole warehouse is attached to this ACCESS DB. I obviously dont want to rewrite this whole thing to mysql but he wants me to make a website that displays all of his products and allows him to sell them from his site.

Question, is there a way to use mysql/php to pull from his access database so t updates as he sells product? If so where do i start?

No. MySQL and Access are two different databases. You can, however, create an ODBC connection to the database using available PHP functionality to utilize an Access database.

http://www.w3schools.com/PHP/php_db...

Michael J

Hey Michael, I am a little nervous about taking on this next project so hopefully you can calm me down a little. This customer wants me to build him a website using php.mysqql that will show his products through a nice custom catalog and make it so people can purchase them online. I can do that no problem. I need to however take the information from his ACCESS DB because his company uses that for there inventory system.

If I use ODBC to access his data, then when someone buys an its will he have to manually update the ACCESS DB himself or can i use this technology to add or subtract info from his DB?

Thanks

I've never used ODBC with PHP. Have you even tried to run an UPDATE query? If you can then you can update the inventory with PHP. If not you will need to find another method to do it or he will need to update manually. At the very least you could generate a report each day for the oerson making the updates. But, if I had to guess, I would bet that you can run an UPDATE query through ODBC.

Michael J