Missing References - Projects on multiple machines...

There are 3 other workstations which use some of the DVB's i create.

My problem is that I have access 2k3 installed on my machine, and want to use some of the libraries functions (like NZ).

Intially (I know this is bad), i tried to copy the reference file to the same path/location on the other workstations. However, I'm not sure if that's the best thing to do.

Seems like the "easiest" approach is to simply recode. However, if it really is as simple as sharing the reference file, i'd just assume do the copy, and have access to the other functions.
Opinions or suggestions?
TIA!

 

You are right, saying the "EASIEST" thing is to recode.

It is not that simple to copy referenced file to app's path/location.

a. You may not have the legal permission to copy said file to other
computer, especially when you are talking something that is part of
Access2K3;
b. Many referenced file (*.dll or other type) need to be registered in
Windows Registry correctly, simple copy/paste does not do that.

Obviuosly, you are referencing Access Object Library in your VBA project. I
do not know what other functions in Access Object Library you have used, but
if you only want to use some functions in Access in your VBA, but not
automate Access do some data process/presentation (forms/reports), then it
is not good thing to do, because you need to launch Access first, just form
making use of NZ(). There is IsNull() function in VB/VBA for you to do
roughly the same thing.

use some of the libraries functions (like NZ).

same path/location on the other workstations. However, I'm not sure if
that's the best thing to do.

really is as simple as sharing the reference file, i'd just assume do the
copy, and have access to the other functions.

 

"a. You may not have the legal permission to copy said file to other computer, especially when you are talking something that is part ofAccess2K3;
b. Many referenced file (*.dll or other type) need to be registered in Windows Registry correctly, simple copy/paste does not do that."

Thanks Norman, I figured both A and B were true.

"You are right, saying the "EASIEST" thing is to recode."
I've assumed the worst and recoded. At least this way i know any workstation can use the code.

"There is IsNull() function in VB/VBA for you to do
roughly the same thing."
As mentioned earlier, I've updated the code. I'm sureyou can appreciate I was after a few more things than just NZ


Thanks again for the help and clarification....