update query help

[chadb]

I have a table named 'Main' on a laptop. I have the same database on our server, meaning that database has the same table named 'Main'. Users will use a laptop and enter data in it over night and I want the user to then upload the data to the database on the server.

In this 'Main' table is a field called 'uploaded' that is a yes/no field. If that record has been uploaded to the server it is marked yes. I was using an append query that would append all of the records where the 'uploaded' field were "no" to the table located on the server. This works fine.

Now I want to change it so that if a user modifies a record that has been uploaded the field 'uploaded' would be changed to "no" (which I can do) and then update the record in the table on the server without creating duplicate records.

There is no single unique key in the table. The reason is becuase we have mulitple laptops upload to the same master database on the server. In order to identify duplicate records I match 'datecreated', 'timecreated', and 'manager' fields.

How do I automate this?

 

[carash77ash]

The easiest way is if you create a replica of your db. Then you can just scyronise the db with the main db.

Have a look at the online help of microsoft access. Working with replicas. It will show you how it is done.

Ash

 

[chadb]

Thanks for the suggestion. My problem is that I have three different laptops that will need to update information each day to the same database. I didnt' see a way to do that with replicas.