Update database

[joeserrone]

Hello,
I wanted your opinion on this: I have 2 sales people that will be using the same exact database to record their information during the day. At the end of the day, I want to create a form where each of the sales people (once they log in to the network) can press a button and upload all the data contained in one table and add it to a database on the network. After the data is uploaded I want to make sure that all data contained in the table of their local database is removed and that the database is compacted and repair, ready for the next day. I basically want to use their individual databases as a slave to collect the data and the database on the network as the master depository for all the data.

 

[odin1701]

Why?

You can have them using the same database file and just adding info in. No need to do that I don't think.

 

[joeserrone]

The sales people will not have access to the network location where the file is located.

 

[Alisa]

Have you looked into haveing them use replicas of the database? Then Access will synchronize for you automatically . . .