Hi Dan.
Now that I have reread your question, maybe what has been suggested so far is overkill. If the users might need to change and then sync any data then a proper syncrhonization routine might be needed. But if only their notes change (or really just are added), copying these into the main database would be quite simple as long as they are creating new records and you are not having to compare "collisions" (two users updated a record, who wins).
In the most simple routine the travelling employees would connect into your office LAN when they were back on site and run some of your code like
* the most simplest case
USE g:\maincompanydata\tMainTravelNotes
APPEND from c:\travelapp\tTravelNotes
>I am in the finishing stages of a Client/Server application. I was just notified that they want to have the ability for our traveling employees take the data with them on the road. The majority of the data is static (read only) but they will be recording notes. When they return to the office they will need to sync their note records into the SQL Server database.
>
>How do I do this?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only