Re: References problem - new variant

Jim, I suspect that there is an issue with one of the libraries on that machine.

Sometimes no libraries show as missing.
But you can solve the problem with:
1. Remove the reference in the database.
2. Unregister the library (with regsvr32 -u).
3. Register it again.
4. Open the database and add the reference again.

If you're not sure how to do that, see:
http://allenbrowne.com/ser-38.html

If that's not the issue, what version of Access, what service pack, and what version of Windows? Particularly the virtualization of folders under Vista can be problematic under different users.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jim Devenish" <internet.shopping@xxxxxxxxxx> wrote in message
news:e1dce181-9b80-4db2-8b89-8e59a82a861b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am familiar with the issue of missing references but I have a
situation that is new to me.

I have a split fe/be system. A copy of the fe is on the server which
is then copied to each user's PC using AutoFE. This has worked well
for some years. However on one PC when the fe is copied to that PC,
it fails to compile with the usual message:
"Can't find project or library". When I open the References window
NONE are marked as Missing. If I click OK (but not Cancel) and then
Compile everything works OK.

Clearly all the references are correct and the required files exist in
the right place. It would seem that simply opening the References
window and then closing it enables the program to find them
correctly. I cannot expect the user to do this every time I issue a
new version of the fe.

On other PCs with the same version of Access and the same files,
everything works correctly.

Has anyone come across this problem? If so, any advice would be
welcome.

Please do not suggest late binding and removing references.

Jim

.

Relevant Pages

  • Re: library missing
    ... Problems with missing references are rather common with Access. ... What you have to do is open the VBA window and then go to Tools - References ... and see what libraries your app is referencing and if any are marked as ...
    (microsoft.public.access.modulesdaovba)
  • RE: How to identify missing libraries in Excel (Office-XP) using VBA
    ... box allows your code to manipulate modules and references. ... > Consequently, I have in some way to identify missing libraries, i.e. ... > libraries that in the VBA editor are found by looking for "MISSING ..." ...
    (microsoft.public.excel.programming)
  • Re: VB5 Question
    ... the References dialog will list the library ... it's expecting as "MISSING". ... There are about 19 libraries checked. ... Dim adoRS As ADODB.Recordset ...
    (microsoft.public.vb.general.discussion)
  • Re: Which Object Library
    ... then select the Tools menu -> References to open the References ... There you'll see the list of libraries your application is ... References dialog window, you'll see the exact path and file name of the ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.setupconfig)
  • Re: DatePart or multi parameter functions return invalid comma error
    ... check your References. ... Go to any code window and ... See if any of them are marked as MISSING. ... Why does the Northwind database not ...
    (microsoft.public.access.queries)