Click to See Complete Forum and Search --> : How to update ServerDB by ClientDB


hazaraSp
07-22-2005, 09:07 AM
:WAVE: Hi all,
suppose I have a database at Web-Server in Access with 2-3 tables. Now almost same structure of Database is there on a client machine which gets updated periodically. Now I want to update/insert some of the rows of some tables of ServerDB by ClientDB's data.
I did this by making two connections one for client & one for Server. Using these two connections I simply read desired records from clientDB and send it to serverDB. It worked well untill site was uploaded. When run through the WebServer, the application generates some error, even for the same computer where ClentDB is placed because it cannot make out the path at client's machine.
Is there any solution to this problem. Please do reply soon.

Regards hazara.

pclement
07-22-2005, 09:22 AM
This is true. There is no way for the web server to see the file on the client unless the file is either uploaded to the web server, or a network share is created on the client to the folder where the Access database is located.