Recordset question

R

Richard

Hi

I am using a split db where the backend is on the server. I use an unbound
form for editing and adding contacts.

When I open a recordset using "SELECT * FROM Contacts", does all the records
come down the line? Or does it when I open a table using "Rs.open
"Contacts", Connection...."?

Which one should I use when I need to add contacts.

Many thaks in advance
Richard
 
B

Brendan Reynolds

When appending new records only using ADO, consider using a Command object
rather than a Recordset. If you still want to open a Recordset, consider
opening an empty Recordset using a SQL statement such as ...

SELECT * FROM Contacts WHERE False
 
R

Richard

Hi Brendan

Thanks for your time taken to reply.

Does what you say means that I have been pulling whole tables down the line
all this while?

Richard
 
B

Brendan Reynolds

I would not like to definitively state 'yes' or 'no' to that question, but
certainly a statement such as "SELECT * FROM SomeTable" has the potential to
retrieve more data than necessary.
 
Top