Using the Access object library without having Access installed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Outlook 2002 I am working with some code that uses the Nz () function from the Access library. I copied the msacc.olb file from a machine that has Access. Even after copying that file to the computer in question and referencing the library the function does not seem to work correctly.

Does anyone have experience in using the Access library within Outlook when Access is not installed locally? Are there other references that might be necessary for Nz() to work? Is there life without Nz()?????

Thanks for your insights.

tim Perez
 
The library just helps with programming. Access must be installed for any of the code to actually work.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 
Although Nz() does more advanced checking I think, you may do something like
this:

Public Function fxNz(varArg As Variant, Optional varReplaceValue) As Variant
If IsNull(varArg) Then
fxNz = varReplaceValue
Else
fxNz = varArg
End If
End Function

Tim P said:
In Outlook 2002 I am working with some code that uses the Nz () function
Click to expand...
from the Access library. I copied the msacc.olb file from a machine that
has Access. Even after copying that file to the computer in question and
referencing the library the function does not seem to work correctly.
Does anyone have experience in using the Access library within Outlook
Click to expand...
when Access is not installed locally? Are there other references that might
be necessary for Nz() to work? Is there life without Nz()?????
 
Back
Top