Fastest rs dump: ADO, DAO, or Append Query?

[Quehay]

I want to create a phone log tool with users creating records in a PC table within the Access app. When they close out I want to export all records not already marked by an "Exported" boolean flag to a common network table (Access).

The question: Which would be fastest (and most bug free)?
1. Use a linked table and append query
2. Explicit DAO db/rs etc. movement of the recordset
3. ADO export

Thanks

 

[scking]

Is high performance a requirement of the database? Are there a large number of changes or users? Unless there requirements, I don't know that the answer is too important as the time differences would be minimal. If the answer to these questions is yes then I suggest you set up your own benchmark tests since any correct answer would have to be built on a knowledge of how you were to be using it.

Steve King

 

[Quehay]

4-5 users tops and rarely more than 1-2 at a time. Users dumping batches of 10-20 records at a time. Total common table records <300.

 

[Junior1544]

personaly, i would just do it the easiest way, with that few records, and only a couple of users, it doesn't realy matter...

just my 2 cents...

--junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[AccessMoron]

Why not let the users update the table as they go?

seems you are making it far to complex