update database online

[viking_p]

Hi,

i am working on one Application, where i am having 10 users on 10 different PC in different location having there own database in ms-access, and there is one remote database on one server, i want my 10 users to update the database daily before leaving the office, and after the office it should show the sale of 10 location to the manager,


i know it can be done in ASP.net but i cant allow my users to have internet all the time, so please help

regards
Viking

 

[programmerskills]

Hi ,


Here is My Suggestion ...

1) Create a Web Service running on Remote Server and write code to Update Database.

2) Create a MultiThreaded Windows Service which is installed on your users Machine.Schedule the Service to run every Evening. Through the Service Call the Web service with the Data you Need to Update the Database.

Thanks
Jay