DAO (Instantiate as Object or use the Data Control)

I guess my question can go in two directions. I create applications
that run multiple queries against a database. Generally speaking in the

past I have used a Data Control (calling it dat1) making it invisible
and have used this whenever i needed it.

dat1.databasename = app.path & "mydatabase.mdb"
dat1.recordsource = "my query"
dat1.refresh

Lately I have seen that most programmers instantiate this when they
need it. For example, in typical DAO style.

dim db as database
set db = OpenDatabase(app.path & "\mydatabase.mdb")

dim rs as recordset
set rs = OpenRecordsets("my table or query")

My question is this. Is it better to instantiate it whenever I use it
or just use one control throughout my program and re-open it when I
need it. Which is better on memory?

My question is not just for DAO, ADO also has a data control or I can
instantiate that as well.

Which is better on memory?

.

Relevant Pages

  • DAO data control or DAO instantiation
    ... that run multiple queries against a database. ... Lately I have seen that most programmers instantiate this when they ... Which is better on memory? ... My question is not just for DAO, ADO also has a data control or I can ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DAO (Instantiate as Object or use the Data Control)
    ... The Data Control is a feature, a native, built-in control, of the separate ... find a newsgroup that deals with VB, and, if possible, databases. ... > that run multiple queries against a database. ... Is it better to instantiate it whenever I use it ...
    (comp.databases.ms-access)
  • Re: custom class module- in another database
    ... > and the VB_Creatable attribute allows other databases to instantiate objects ... > won't be able to instantiate the object in another database. ... > 'Abs' is the name of a built-in VBA function. ... >> Public Property Let avviso ...
    (microsoft.public.access.modulesdaovba)
  • Re: Any alternative to a Data Control?
    ... "third dialog box" in the Data Wizard where it asks to ... I finally got the Data Control to work. ... datasource but does not refresh with changes. ... The extra work required to deal with database in classic VB is one major ...
    (comp.lang.basic.visual.misc)
  • Re: Help - Access with VB
    ... No, there are a few different ways to access data in a database, but the ... data control is probably the easiest. ... connection, command and recordset objects, initialising these to ... string should look something like: ...
    (microsoft.public.access.queries)