|
|
Posted by Scott McDaniel on 10/01/31 11:24
I have a VB app which stores information in an Access 2000 db. The VB app
handles multiple users (it's a logbook type of application, users share
lookup tables but don't share information among themselves - IOW, I couldn't
see your log entries and you couldn't see mine).
We're adding a web interface to the package - basically a scaled down data
entry interface to allow users to add log entries without being at their
workstations. The web version will be storing data in a SQL Server 2000 db.
I need to be able to synchronize data between the two - if a users
edits/adds a log entry in the desktop version, they need to be able to
synchronize the desktop and web (this is done via a button click, no
"realtime" updates). Same scenario with the web side, but the web interface
won't acutally be able to synch with the desktop - the user would have to
initiate the synch from their workstation. We've pretty much worked out the
synch logic path, and we're working on acutally interfacing with the SQL
Server.
Can this be done reliably using a standard ADO connection between the
desktop and the web site? I would imagine traffic would be somewhat
minimal - on average, no more than 100 records would be added or updated.
I've done some testing on this, and with 20 - 50 records it seems to work
fine both ways.
Suggestions of better/more reliable methods would be most appreciated, and
thanks for your time
Navigation:
[Reply to this message]
|