[AccessD] Odd Behavior on one profile on one machine

[RANDALL R ANTHONY]

Charlotte,
Had a similar issue.  In short, user got new workstation and could not invoke an Excel report from the Access app.  Same results, works fine on another machine, works for other users on his  machine.  There appeared to be a "ghost" install in his profile in that it was loading the 15.0 Excel library when it should be 14.0.  Once I submitted the fix below and gave them a screenshot, the network team finally fixed his issue.

Under HKeY_ClASSES_ROOT >> TypeLib >> {00020813-0000-0000-C000-000000000046}
There was an additional registry entry 1.8 and from the square outlined indicated, it was listed as Excel 15.0 Object library.  I exported this to save, then deleted it from the registry.  Once I did this and restarted the workstation, I was able to use the /resrvr32 switch to register the Excel.EXE file in his office directory.

Regards,

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, October 20, 2016 1:57 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Odd Behavior on one profile on one machine

I don't believe it's always been this way, and there is nothing anywhere to hide the button for any reason.  No code, no macros, no nothing!  Giving him a higher level of permissions didn't change anything.  His screen resolution isn't any different from standard, and I've run out of things to try.  It sounds like a local profile issue, but the network people blame Access.

Charlotte Foust
(916) 206-4336

On Thu, Oct 20, 2016 at 10:48 AM, David McAfee <davidmcafee at gmail.com>
wrote:

> Has it always behaved this way with him, or did it just start doing so?
>
> Have you stepped through the On open of the form?
>
> Is there something being hidden by his login or role?
>
>
>
>
>
> On Thu, Oct 20, 2016 at 9:52 AM, Charlotte Foust < 
> charlotte.foust at gmail.com>
> wrote:
>
> > The app lives on a server, and they all share it.  Access is 
> > installed on their machines.  I can't think of a reason why it would 
> > behave
> differently
> > from one profile on one machine.
> >
> > Charlotte Foust
> > (916) 206-4336
> >
> > On Thu, Oct 20, 2016 at 9:47 AM, James Button < 
> > jamesbutton at blueyonder.co.uk>
> > wrote:
> >
> > > Seems to me to be a corruption of some part(s) of the app that are
> within
> > > his
> > > user profile on that particular system.
> > >
> > > Maybe uninstall and then re-install the app ( and  Access 
> > > run-time?) he
> > is
> > > using
> > > -
> > > Maybe copy the current one to a store for compirism  with the 
> > > recreated one and any other versions you have easy access to.
> > >
> > > JimB
> > >
> > > -----Original Message-----
> > > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On 
> > > Behalf
> Of
> > > Charlotte Foust
> > > Sent: Thursday, October 20, 2016 5:22 PM
> > > To: Access Developers discussion and problem <
> > accessd at databaseadvisors.com
> > > >
> > > Subject: [AccessD] Odd Behavior on one profile on one machine
> > >
> > > There is an Access app in use in public affairs office for the 
> > > State of California (I didn't build it) that is used by multiple 
> > > people but on
> one
> > > machine, one person is missing part of the form when he logs in.  
> > > The missing button would allow him to add new records.  Anyone 
> > > else logging
> > in
> > > on his machine has no problems, and he has no problems when 
> > > logging
> into
> > > someone else's machine (according to him).  I've been scratching 
> > > my
> head
> > > over this for months because I can't recreate it.  Any ideas?
> > >
> > >
> > > Charlotte Foust
> > > (916) 206-4336
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
.