Use recordset or table?

  • Thread starter Thread starter George Lob
  • Start date Start date
G

George Lob

Let's say you have a form in a front end db that has links to tables in a
backend db.

1. When should you set the record source to the linked table vs a recordset
of the table?
2. Is there a difference in performance between the two?
 
When you say "recordset of the table", I assume you mean
an ADO or DAO recordset, with which you are adding
another layer to the process.
Using the built-in Jet engine is in most cases faster
than using ADO or DAO to manage recordsets. I would
suggest using linked tables.
 
Back
Top