By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,508 Members | 2,904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,508 IT Pros & Developers. It's quick & easy.

VB - "Available References" problem

P: n/a
hello,

i am trying to figure something out. the facts:

- i have an Access 2000 app that ive converted to Access 2007 (windows
Vista)

- it uses several external references, DLLs and an EXE.

- these are managed in the VB IDE's Tools-->References... dialog.

- one of the available references is an .EXE that belongs to my team,
its location is in "C:\Users\foo\bar\someFile.exe".

- i now need to update this reference to point elsewhere.

....however, whenever i use the "Browse..." button to point to the new
location (same file name), it ignores the change, and the available-
reference remains pointing to the old location.

how does the Access VB IDE populate this list? is there a way i can
permanently remove the old available-reference from it? then maybe
"Browse..." will successfully pickup my new path.
thoughts? thanks!

sm
Jan 3 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Thu, 3 Jan 2008 15:27:37 -0800 (PST), SpaceMarine
<sp*********@mailinator.comwrote:

EXEs used as references are rather unusual. I have to assume this is
an ActiveX EXE. As such, it needs to be registered using:
regsvr32.exe <path_to>someFile.exe

Then try setting the reference again.

-Tom.
>hello,

i am trying to figure something out. the facts:

- i have an Access 2000 app that ive converted to Access 2007 (windows
Vista)

- it uses several external references, DLLs and an EXE.

- these are managed in the VB IDE's Tools-->References... dialog.

- one of the available references is an .EXE that belongs to my team,
its location is in "C:\Users\foo\bar\someFile.exe".

- i now need to update this reference to point elsewhere.

...however, whenever i use the "Browse..." button to point to the new
location (same file name), it ignores the change, and the available-
reference remains pointing to the old location.

how does the Access VB IDE populate this list? is there a way i can
permanently remove the old available-reference from it? then maybe
"Browse..." will successfully pickup my new path.
thoughts? thanks!

sm
Jan 4 '08 #2

P: n/a
Tom van Stiphout <no*************@cox.netwrote in
news:ip********************************@4ax.com:
EXEs used as references are rather unusual. I have to assume this
is an ActiveX EXE. As such, it needs to be registered using:
regsvr32.exe <path_to>someFile.exe

Then try setting the reference again.
Doesn't setting a reference in Access to an unregistered library
register it?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jan 5 '08 #3

P: n/a
On 05 Jan 2008 00:55:09 GMT, "David W. Fenton"
<XX*******@dfenton.com.invalidwrote:

If it does, it's a feature I am not aware of.
I'd rather do it explicitly.

-Tom.

>Tom van Stiphout <no*************@cox.netwrote in
news:ip********************************@4ax.com :
>EXEs used as references are rather unusual. I have to assume this
is an ActiveX EXE. As such, it needs to be registered using:
regsvr32.exe <path_to>someFile.exe

Then try setting the reference again.

Doesn't setting a reference in Access to an unregistered library
register it?
Jan 6 '08 #4

P: n/a
On Jan 3, 5:27 pm, SpaceMarine <spacemar...@mailinator.comwrote:
how does the Access VB IDE populate this list? is there a way i can
permanently remove the old available-reference from it?
i was able to do this by unregistering the EXE in question. from the
command console:

C:\Users\foo\bar\someFile.exe" /unregserver

....gone from list. new one could then be added properly.
sm
Jan 10 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more Microsoft Access / VBA Questions on Bytes