Open a recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
I have a table for which I've declared a recordset as follows:

Dim rst As Object

This is the main table I will be adding record to in my code. I have another
recordset which is used for lookups. It is declared as follows:

Dim rst2 As DAO.Recordset

Why are these different types? I'm still somewhat a newbie. A lot of what
I've accomplished in this app is attributed to help on this forum. These
would have been recommended by different people at different times. The app
works, I'm just trying to understand a little better.
 
The first instance is an example of "late binding" the second is an example
of "early binding". See the following MS Knowledgebase article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;245115 for more
information. There are advantages and disadvantages to each, but the early
binding method is usually preferred.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top