missing built in object types and intrinsic constants

[heidi]

the tabledef type is not defined, nor are the db-
constants (as in dbText), and who knows what else.

this means that i cannot write code to create a table.

how do i get all these missing features back?

 

[Cheryl Fischer]

I suspect that you are missing a reference to the Microsoft DAO x.xx Object
Library (where x.xx is 3.6 for Access 2000 and newer or 3.51 for Access 97
and older).

To set a reference, press Alt-F11 to open the VBA editor. Then, from the
menu select Tools|References. Scroll through the list of available
references until you find the one mentioned above and put a check mark in
the box.

hth,

 

[Scott McDaniel]

The first thing to check for is missing references. From the VBE (code)
window, click Tools - References. See if any are marked MISSING. If they
are, note which one it is (write it down, as the names can be very similar),
then exit the references dialog and reopen it. Find and check the errant
reference, and see if that helps.

If none are marked MISSING, then perhaps you have recently upgraded to a new
version of Access which does not, by default, have a reference set to the
DAO objects. If so, go to the reference dialog and find and check DAO xx,
where "xx" is the version of DAO you require (which is often the biggest
number).

For future posts, please include the Access version you are working in ...

 

[heidi]

Thanks, both of you - it was the missing reference.