Updating a table

Hi , i have a Point of sale  program in 2 diferents stores, the owner of the stores want that when he enter the inventory in the store   1 that is where he recieve the products the inventory of the store 2 get update , and then he send the products to the  store numer 2, the thing is that he don,t have the enter the product in both stores, the database is in access and the program is in Vb6.0 i hav e single table for the products that table have a relation with the orders detail table. each program have a individual data base in each store. I don't have any idea to do this, can you give me some advise or recomendations.


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Robberbaron (robr)Commented:
You need to link the 2 databases & the 2 stores ....

1/ Obvious, best , but difficult, method is via a web page. Both programs access the same database , stored on a web server somewhere in the world. Continuous syncronization of both ends as they are accessing the same database.  But this has some difficulties. Security, complexity, cost...

2/ Are both stores on cable or permanent internet connection ?  Perhaps you could open a specific port or FTP directory for data transfer. And then monitor this location for updates. But probably not very secure.

2/ an easier method may be to get each program to send an email to the other side. Perhaps a special formatted message containing the SQL code to modify database as an attachment. Configure an update program to be associated with the new file extension you use. Creating and reading the transfer file would be quite easy. (just the SQL code you use to update the local database.  So long as each end reads email regularly (ie every hour or less), the databases should be in reasonable sync for your clients needs.

3/ other method would be for the transfer file to sent via floppy disk or usb disk. but this would not be very timely updates of the database

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Robberbaron (robr)Commented:
4/ Even better for option 2 is to create a VPN between the 2 sites. VPN routers are cheap & provide a secure virtual connection between the sites. Then the remote site program know to connect the head office via a static IP

5/ also watch http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/VB_Databases/Q_21478981.html
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.