Microsoft DAO 3.6 Object Library

[Guest]

Hello,
I am suing “Microsoft DAO 3.6 Object Libraryâ€, in one of my server I do not
see this in Tools -> Reference as an option. Where can I download it?
Thanks,
Jim.

 

[Douglas J. Steele]

Access 2000, 2002 and 2003 should all have it.

You could try going to http://download.microsoft.com and search for the Jet
4.0 Service Pack (I can't give you a specific reference, because it depends
on the OS you're running)

On the other hand, why do you need DAO on the server?

 

[Guest]

Hi Douglas,
Thanks for the reply, does DAO come with Access? I did not find anything
under Office but under Common Files/Microsoft Shared I found dao360.dll and
include that, it seems working fine. I am suing DAO recordset in the VB code,
that is why it requires it, is there any other way to use recordset?
Thanks,
Jim.

 

[Douglas J. Steele]

If you go to the DLL Help Database at http://support.microsoft.com/dllhelp/
and do a search for dao360.dll, you'll find it not only comes with Office,
but with most of the newer operating systems. Since it's used in many
different places, it gets installed under Common Files/Microsoft Shared,
just like such other components as the Equation editor and the Proofing
tools.

Is your VB code actually running on the server (eg. by a service)? If so,
then yes, you will need DLLs to be registered on the server. If, however,
your code is on the server, but it's being run from a workstation, the DLLs
only need to be registered on the workstation.

You can also use ADO recordsets, but if you're strictly going against a Jet
database (i.e. an MDB file), DAO is probably better.