Access 'Library not registered'

[James Williams]

Hey all. Have a problem where a homegrown VB app we use to access an
Access Database has ceased functioning. Here's the odd part--one and
ONLY one user can still use the app just like he could before. All the
rest of the users (including the administrator user) can't run the
application.

When users try to do the lookups into the Access Database, they get
Run-Time error '-2147220992 (80040200)': Library not registered

Any ideas? MDAC 2.8 SP1 on Win2000 SP4 w/ all MS patches.

Thx in advance!

(j)
James

 

[Douglas J Steele]

This sounds more like a VB problem than anything to do with Access.

From the sounds of it, your application is using a component (probably a DLL
or OCX) that only exists on the one machine. In other words, the
installation program is doing an incomplete job.

 

[James Williams]

Good point, except it's a Citrix server. Obviously, a not-so-minor
detail I left out... Sry--was in too big a hurry to get this posted.
All of this is happening on a Citrix server, and all users (including
the functional one) have mandatory profiles. And no changes have been
made to the app in two months or more.

We've tried duplicating the profile, to no avail, so it isn't HKCU
registry settings. And I can't find any access denieds in Regmon or
Filemon.

What I am seeing is that just before failure, users are getting NOT
GRANTED in Filemon when they attempt to lock the database (although
there are several successful locks as well). Then, 30 steps later, we
get a SHARING VIOLATION on the database's .ldb file (even if we're the
only ones using the db).

Thanks for pointing out my mistakes, Douglas. 8)

(j)
James

 

[Douglas J Steele]

What permissions do they have on the folder where the MDB resides?

 

[James Williams]

Everyone: Full