Is there a way to make the DAO library always available
when I write VBA code? Or do I have to add it "manually"
through Tools - References for each new Access program?

Arthur wrote:

>Is there a way to make the DAO library always available
>when I write VBA code? Or do I have to add it "manually"
>through Tools - References for each new Access program?

How many new Access programs do you create? Personally, I
don't find it to be a big deal (though it is annoying).

You could create a "template" mdb file that has all your
favorite options/references/modules set the way you want
them. Then instead of using New within Access, first copy
the "template" mdb file and use the copy to get a new
program jump started.

--
Marsh
MVP [MS Access]