MISSING library 1

[boatdrinks]

where can I download the microsoft dao 2.5/3.5 library? It shows up as missing and Access won't recognize Date()

 

[EBGreen]

So it is not in the list when you try to add a reference to it?

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[boatdrinks]

Yes it is in the list with a check mark next to it, but it says MISSING.

 

[PHV]

And no other version of DAO you can check mark ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[EBGreen]

I don't really think that is your problem. I may be wrong and if so I'm sure that someone will correct me, but the only DAO library that I ever reference is the DAO 3.6 Object Library an I have no problem with the date function. Not to metion that I can think of no reason why a missing DAO reference would have any bearing on a built in VB function in the first place.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[PHV]

I can think of no reason why a missing DAO reference would have any bearing on a built in VB function in the first place
When a project has MISSING reference then lot of VBA builtin functions become unavailable.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[EBGreen]

I stand corrected.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[SDelgado]

Go to microsoft.com search for mdac_typ.exe I had the same thing happen just recently with all Access programs at my job. Not sure what caused it but was probably some update push on the network that messed up a dll file somewhere. Anyway, it works now.