[AccessD] Ribbon getVisible issue

[Gary Kjos]

I'm retired now and haven't done any Access development for other
people to use for many years.  But I'm happy to see traffic on the
AccessD list!  Hope you get some suggestions!

GK

On Tue, Apr 13, 2021 at 2:53 PM Ryan W <wrwehler at gmail.com> wrote:
>
> Hey all, Sorry to bombard the group so much... I'm in active development
> again and sometimes.. I just can't figure out the issue.
>
>
> So I am attempting to call a function to determine if a ribbon group is
> visible. This function goes out and checks the roles the user calling the
> function has.
>
> The problem becomes, the ribbon initializes before my relinking procedures
> do... so if I call the function to get the roles, it's calling it with
> cached or 'old' stale credentials in some cases.  I can see with exec
> sp_who on the back end the handle stays open with my test username
>
> So because that SPID is held open, the query will return my elevated
> privileges for an unprivileged user.  This ONLY seems to be the case if I
> try and use the function on the remote table for ribbon manipulation.
>
> Here's an image of the user BTJ logged in, but the SPID being held on the
> SQL side is my username / spid (I was the last one to log in, before
> logging in as BTJ).
>
> https://i.imgur.com/9SsE1Dz.png
>
> Unless there's a fix for this that makes sense I may have to make a local
> permissions table so that the ODBC connection string doesn't impact these
> tables before my refresh links code fires.
>
> Hope that makes sense?
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-- 
Gary Kjos
garykjos at gmail.com