473,325 Members | 2,671 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Available Access References

Does anyone know how Access (97 or 2K) gets it's list of available
references? I understand that only the "checked" items are in the
references collection, but where does it get the initial list from? It
has to be a dynamic list of some sort, because after having installed
97 and 2K on the same machine, some older references no longer appear
in the list (but are accessible if you browse to them).

Thanks in advance
Mike
Nov 12 '05 #1
2 1669
I am sure those all are registered DLLs that Access pulls from the
registry. I don't know where from specifically - must be from hundreds
of those GUIDs you see there.
New installations replace those references with updated DLLs even though
sometimes the actual files seem to remain on the disk :-(
Do a registry search for one of the strings giving you the path to a
reference DLL.

Pavel

Mike Storr wrote:

Does anyone know how Access (97 or 2K) gets it's list of available
references? I understand that only the "checked" items are in the
references collection, but where does it get the initial list from? It
has to be a dynamic list of some sort, because after having installed
97 and 2K on the same machine, some older references no longer appear
in the list (but are accessible if you browse to them).

Thanks in advance
Mike

Nov 12 '05 #2

I think I have found a likely spot shortly after my original post -
HKLM/Software/Classes/TypeLib - I have so far been trying to confirm it
somehow.

Within each GUID folder, there are sub folders that are numbered (ie.
2.1 or 2.0). There is a value in this folder that matches the reference
description that appears in the Access Reference Window. Under that
numbered folder are usually three other folders, one of them being
numbered '0'. Win32 or Win16 are folders under that one and contain a
value that matches the file path. I beleive Access is getting them from
here, although I hoped there would have been an easier source to work
with.

New installations do not replace any of these keys or values, but add
new ones under the same GUID. I think Access gets the highest numbered
(ie. 2.1 or 2.0) as the newest and ignores the others. This is probably
supposed to help prevent conflicting references from being made.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Thomas Miller | last post by:
Hello, I have built a c# class library (I will call it "Assembly1"), and built an installer that installs it. It is working well. I created a new asp.net application, right-clicked on references...
5
by: deko | last post by:
After developing an MDB in Access 2003 on WS03, then making it into an MDE and deploying it on a WinXP box with Access 2003 installed, I get this error: Function is not available in expressions...
18
by: Steve | last post by:
Hi I have a really weird problem and any assistance would be welcome. I have developed an app in Access 2002. The app runs perfectly on the development machine. I have packaged the app using...
5
by: Jozef | last post by:
I have an MDE file that is blowing up with "Error 3075 Function Not Available", which is normally a reference issue, but, I have no missing references. It seems that offending function is a...
5
by: S.Tobias | last post by:
Since I haven't found any recent reference to it in csc or clc, I would like to bring Readers' attention to the apparent availability of C90 Standard in electronic form from www.ansi.org. I...
3
by: pw | last post by:
Hi, I created and distributed an Access 2003 MDE. When the user opens up a form he get's an error message :Function is not available in expressions in query expression 'Trim( & ", " & )'. ...
4
by: Jim | last post by:
Professional Systems Analyst, with 23 years of systems experience at a large well-known corporation, available to work on your Microsoft Access database. Enhancements to existing applications, or...
5
by: elie.constantine | last post by:
Hello A person developed a Microsoft Access Solution and gave me the MDE file. When I tried to run it, I got "Function is not available in expressions in query expression 'Trim([......" Error. ...
4
by: SpaceMarine | last post by:
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....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.