I
ibsmith
Guest
I have installed Access 2000 into a non standard directory on a 2nd hard
drive on my PC.
Everything works fine until I try to distribute the app using runtime
access.
When I start up the app on the users PC I get a dialog box,
heading "Error",
text "The expression you entered has a function name that can't find",
the only button allowed is OK.
I believe that this is down to the Reference for MSACC9.OLB (Access), which
on the original PC was on the G: drive, but on the users PC is on the C:
Drive.
I am unable to alter the reference on my PC because the file is in use,
either thro the dialog or thro code. Ideally I would like to move the file
MSACC9.OLB to a known dir on the C: drive and then during the install on
the users PC copy the file to that dir.
So I guess the question is, how do I alter the reference on my PC for MSACC9.OLB
such that it points to a directory on my C: drive and not to my G: drive ?
Any ideas or thoughts would be welcome.
drive on my PC.
Everything works fine until I try to distribute the app using runtime
access.
When I start up the app on the users PC I get a dialog box,
heading "Error",
text "The expression you entered has a function name that can't find",
the only button allowed is OK.
I believe that this is down to the Reference for MSACC9.OLB (Access), which
on the original PC was on the G: drive, but on the users PC is on the C:
Drive.
I am unable to alter the reference on my PC because the file is in use,
either thro the dialog or thro code. Ideally I would like to move the file
MSACC9.OLB to a known dir on the C: drive and then during the install on
the users PC copy the file to that dir.
So I guess the question is, how do I alter the reference on my PC for MSACC9.OLB
such that it points to a directory on my C: drive and not to my G: drive ?
Any ideas or thoughts would be welcome.