I created a website for a client w/ an Access database backend. It holds info about products and pricing. I just use it to display the products onto the website. My client uses a Point of Sale program called Cash Register Express. It is a Windows based program w/ an Access database backend.
My client wants for me to link the website database to the POS software’s database, so that when customers make orders from the website, the POS software will automatically deduct inventory and manage sales in real time.
How would I come about doing this? I have never connected a remote database to a local one before.
The reps at the company that sells Cash Register Express told me that it is possible, but I would have to know how to program that.
Can anyone please give me some pointers or links to any tutorials?