Dim db As Database?

  • Thread starter Thread starter Svein Petter
  • Start date Start date
S

Svein Petter

Am still messing about exploring examples here. I find "Dim db as Database"
or "TableDef" in many examples. However, they don't appear as an option in
the popup alternatives, meaning Database or TableDef is not defined. Why?

(sometimes I need to remind myself that there is no such thing as a "stupid
question"...)

Svein Da Newbie
 
Svein

You didn't mention the context in which you found the Dim statements -- but
I'd guess you were looking at code fragments. Not sure how that applies in
the queries newsgroup...

Not sure what "popup alternatives" you are referring to...

Note that later versions of Access, by default, reference the ADO object
model, not the DAO model. The examples might more correctly read:
Dim db as DAO.Database
or
Dim db as ADO.Database
to reduce confusion/ambiguity.

More info, please...

Jeff Boyce
<Access MVP>
 
Open a code module and remove the reference to ADO and set one for
Microsoft DAO 3.6.
 
I will check this out. I apologize for bad terminology and maybe for turning
to the wrong group, it is basically a vb question.

I am working on the 2000 version. By the "popup alternatives" I meant when
you type "Dim db as " a popup list appears for the definitions you can use
as db. I tilted to the direction of looking for a more enhanced version of
Access (maybe a developer version) than what is on the ordinary office prof
package.

I will test this after work today.

Thank you, Jeff.
 
Back
Top