insert update tables in another db

[mjoerge]

i'm working for an organization with sales people operating off-line, adding orders into an access db. when they get back into the office, they need to insert or update sales records from their local database into a backend database containing data from all the sales people.

i've tried looking into syncronization to solve this problem, however that will result in a lot of overhead since each sales person only needs to see its own orders. syncronization seems to syncronize all the data in the backend database with the local database.

can this be done more efficiently using vb? can anyone give me an exampel of what that vb code might look like?

 

[Adrianna]

I know this isn't the best way to do it, but...I've done it this way:

My client locations (across the nation) have their own database versions. (On 9 servers across the nation)

Each of those versions has an Export form...that e-mails the relevant table to the home office (Then resets all of the [ChangeAdd] fields to 0)

The home office version of the database has an IMPORT form. This form runs a macro that:
- Imports the tables into the "parent" database
- Queries to check all of the [ChangeAdd] fields for -1, meaning that the indicated fields have been changed or added, and runs and append query to the "parent's" master table
- Then it deletes the clients table
- And Compacts the Database

This allows each of the clients to work off of their own database, while still allowing the parent to monitor, review, and report on all of it's subordinates.

Hope that helps!