Referencing Access library without Access installed locally

[twperez]

I am trying to use the Nz() function for a project in Outlook 2002 that requires the Access object library. ALthough I do not have Access installed locally, I copied the msacc.olb file from another machine. Now the library appears under references, but Nz() does not seem to work. There is no error message, but the outlook field data (e.g. Nz(OutlookField) does not come over.

Is there a way to use the Nz function without the Access library? Are there other references necessary when Access is not installed locally? Short of removing Nz from the entire project, I am open to suggestions.

Thanks very much, Tim Perez

 

[Cheryl Fischer]

Open Access and go to Access Help. Click on Contents | End User License
Agreement. Scroll down to:

"2. DESCRIPTION OF OTHER RIGHTS AND LIMITATIONS.
...
Separation of Component Parts. The Software Product is licensed as a
single product. Its component parts may not be separated for use on more
than one Device unless expressly permitted by this EULA."

Copying the Access Object library (one of the component parts) to another
computer is a violation of your end-user license. With a legal copy of MS
Access installed on the computer where you are developing your Outlook
project, you can legitimately set references to Access Objects, VBA, etc.
Of course, if your Outlook project is to be distributed to other users, they
would also have to have a full copy of Access installed on their computers,
as you may not distribute Access components.

--
Cheryl Fischer

I am trying to use the Nz() function for a project in Outlook 2002 that

requires the Access object library. ALthough I do not have Access installed
locally, I copied the msacc.olb file from another machine. Now the library
appears under references, but Nz() does not seem to work. There is no error
message, but the outlook field data (e.g. Nz(OutlookField) does not come
over.

Is there a way to use the Nz function without the Access library? Are

there other references necessary when Access is not installed locally?
Short of removing Nz from the entire project, I am open to suggestions.

 

[Bill James]

Create your own.

-----Original Message-----
I am trying to use the Nz() function for a project in

Outlook 2002 that requires the Access object library.
ALthough I do not have Access installed locally, I copied
the msacc.olb file from another machine. Now the library
appears under references, but Nz() does not seem to
work. There is no error message, but the outlook field
data (e.g. Nz(OutlookField) does not come over.

Is there a way to use the Nz function without the Access

library? Are there other references necessary when
Access is not installed locally? Short of removing Nz
from the entire project, I am open to suggestions.