Updating recordsets from a remote PC

  • Thread starter Thread starter Wes Peters
  • Start date Start date
W

Wes Peters

We have a situation where remote PCs will download records, make changes,
and upload the records back to the SQL server. Currently we are converting
the recordsets to xml streams and using a web page to accomplish this.

What are some other ways to do this? The client side app could be either
adp or mdb.

Thanks,
Wes
 
If the SQL-Server's port 1433 if blocked by a firewall, then this is
probably the best way of doing your transfers.
 
Hello,
You wrote on Thu, 15 Sep 2005 09:09:50 -0500:

WP> We have a situation where remote PCs will download records, make
WP> changes, and upload the records back to the SQL server. Currently we
WP> are converting the recordsets to xml streams and using a web page to
WP> accomplish this.

WP> What are some other ways to do this? The client side app could be
WP> either adp or mdb.

With mdb, download the records into a temporary table; open a form bound to
that table and have the user work with the records; then upload from the
temp table back to sql server.

Vadim Rapp
 
Back
Top