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

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"James Williams" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

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 wrote:
> 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.
>

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"James Williams" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 wrote:
> > 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.
> >

Everyone: Full

Douglas J Steele wrote:
> What permissions do they have on the folder where the MDB resides?
>