Re: References problem - new variant

On Jan 17, 11:24 am, "Allen Browne" <AllenBro...@xxxxxxxxxxxxxx>
wrote:
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.shopp...@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

Thank you Allen. That offers some promise. I will give it try.

Jim

.

Relevant Pages

  • Re: Library Database
    ... Access fixes up the reference ... Typically my applications have one front end referencing 3 libraries. ... The only issue I am aware of is when you have the same name library database in multiple places on a users computer; Access always chooses its preference in a certain order. ... you do not get auto-completion or even simple compile checks. ...
    (comp.databases.ms-access)
  • Re: How to display only 3 letters of a last name in field
    ... do you want to know which lines are "checked" in the reference window? ... I can do the task of unchecking the MISSING one, ... The References are the "extra" program libraries that Access needs to do its ... installed it, but does not exist on your work computer, it's "missing". ...
    (microsoft.public.access.queries)
  • Re: How to display only 3 letters of a last name in field
    ... The missing reference may really BE missing. ... If you uncheck the MISSING one and leave it unchecked, ... The References are the "extra" program libraries that Access needs to do its ...
    (microsoft.public.access.queries)
  • Re: Library Database
    ... about Dbs to which you set a reference in the VBA references section. ... main database, how do I get the names of all the forms in all the Dbs? ...
    (comp.databases.ms-access)
  • RE: Error Message "User-defined type not defined"
    ... DAO and ADO both contain Database objects in their ... But, if you reference both libraries, you need to ... DAO preface in the original code. ...
    (microsoft.public.access.modulesdaovba)