Updating table from another access database

[Access Virgin]

Hello there,

Just looking for some advise. I have a master database that is based in the office and stored on the server. However the nature of our work takes us out of the office to visit clients at remote sites. During these visits answers will be recorded to a number of questions, usually in MS Word on a laptop. These answers are currently held in a table on the master database so when they return to the office they have to sit down and input the results.

I was going to design a small database that contained a table identical to the one held in the master database in the office and a form so that they could enter the results to the questions directly.

What I was then hoping to do was to import the new entries to the master database table when they return to the office so they dont have to re-enter the results. So what would be the best way to go about this? Would I need to design an Append query to add this new data from the small database table to the current master database table? I dont want to import the data from MS Word into MS Access as this would involve the users having to do too much. I want them only to have to click on a button to copy across the data.

All advice will be much appreciated.

 

[dcx693]

Yes, you're on the right track. An Append query is precisely what you need.

Here are the major steps. (For more detail, do a search in this forum for update queries, and look in the Microsoft KnowledgeBase.) First link to the database table that has the new data from the master database. If the new database table will only contain new records (and not updates to existing records) create a select query to find records in the new table that don't exist in the master. Change that query into an append query, and run it. You can save the append query once you're sure it works correctly and run it again the same way you'd run any other query.