DAO 3.6 always missing

[Nugimac]

Access 2000 SP3 Jet SP8, Win2000

Whenever I open any database, the reference to DAO 3.6 is marked as missing.
If I create a blank new database, the reference to DAO 3.6 is marked as
missing.
This is very annoying. Is there any permanent fix?
This doesn’t happen with Access 2003.

Nugimac

 

[Douglas J. Steele]

Sounds as though your application is being created on one machine, and
you're trying to open it on a different machine that doesn't have the same
service packs installed as on the first machine.

 

[Nugimac]

Thanks Douglas for your thoughts, I wish it was that easy. My computer has
all the service packs for A2000. The first app I tried in A2000 was Albert's
Shiftkey 2000 and it had the problem with the missing DAO 3.6. Any databases
I create on the same machine also have the same missing DAO 3.6. Isn't there
any way to tell A2000 to permanently open with a reference set to DAO 3.6?
What happens to all the apps written in A2000 that people install on their
personal PC's with Office 2000?

 

[Douglas J. Steele]

You might have a couple of different issues here.

First, "Isn't there any way to tell A2000 to permanently open with a
reference set to DAO 3.6?" No, there isn't. By default, Access 2000 (and
Access 2002) only sets a reference to DAO. This shortcoming has been
corrected in Access 2003.

However, that's got me wondering what you mean by missing. When you say that
any database you create on the machine has "the same missing DAO 3.6", do
you mean that when you go into the References dialog, there's a label
MISSING: beside the reference for DAO 3.6 at the top of the dialog, or are
you simply saying that the reference to DAO 3.6 isn't checked, and you have
to scroll through the list to find it and check it?

If the latter, then what I wrote above is the explanation.

However, once you've added the reference to DAO 3.6, the reference lives in
the database (i.e.: there's a pointer in the database to C:\Program
Files\Common Files\Microsoft Shared\DAO\DAO360.DLL). When someone else opens
that MDB (or MDE), the reference to DAO 3.6 will be there. If they don't
have the same version of the referenced library (or doesn't have it at all),
when you go into the References dialog, you should see the MISSING: label
beside the reference.

Did you open Albert's application, or did you import it into your
application?

 

[Nugimac]

This time you understood exactly what I meant. (esp?) Thanks for the great
explanation, now I understand how it works. I have read many times that in
A2000 you have to manually set the ref to DAO 3.6, now I understand what that
entails and that once set, the reference stays with the application.

 

[Douglas J. Steele]

Glad it helped, and that my typo that "By default... only sets a reference
to DAO" didn't confuse you (that should, of course, have been that it "only
sets a reference to ADO"!