Re: Running update queries with update permissions for an read onl

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: FRED (FRED_at_discussions.microsoft.com)
Date: 09/11/04 

Date: Sat, 11 Sep 2004 07:23:03 -0700

I'll give you more detail. On opening, the database is running a query to
update local invoice tables from an SQL database (odbc) so to have the query
update the invoice value user must have update privilege but when they
consult the table trought a form they shouldn't update anything. I know that
I could have the form beiing read only but when this form will be use by full
data user they will not be able to update. I thought it would be more simple
to run the update query on opening with update privilege. So if there is a
way, let me know even if it's complicated, I could do some coding to make it
work.

 thanks for your help.

FRED

"'69 Camaro" wrote:

> Hi, Fred.
>
> You want to give read-only users _temporary_ update permissions? The
> intention of read-only users is to prevent them from making _any_ changes to
> the data.
>
> What you ask is doable, but the tasks required to provide this "temporary"
> capability would be a convoluted mess. Why not create a new group within
> your workgroup that has read-only permissions on all objects, except for
> these four queries, and make your designated users members of this new
> group, instead of the read-only group? That way, you'd have a group for
> people who need a bit more than read-only privileges and a group available
> for people who really _should_ only have read-only privileges.
>
> HTH.
>
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips.
>
> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> will be forwarded to me.)
>
>
> "FRED" <FRED@discussions.microsoft.com> wrote in message
> news:1AD06722-D678-4ABB-9A7E-A47435422BA0@microsoft.com...
> > My Db is secured and I would like the read only user consult an updated
> DB.
> > The problem is when the db is opening it runs four different update
> queries
> > in background but doesn't work when logged on as a read only user. Is
> there a
> > way to run these four queries with temporary update permission.
> >
> > Thanks
> >
> > FRED
>
>
>

Relevant Pages

  • Re: SQL vs. Access
    ... I can't say I know the rules in depth, but typically if you are using /linked/ tables in Access and you're not using a "pass-through" type query, then Access could be reading all the data it "thinks" is necessary to do the necessary joining/filtering, which may require a lot of data to pass between our SQL database and Access, which could I assume lead to behaviour which either looks like a hang or is a hang. ... Security. ... plain text logon/password information into your Word file or a .odc file. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Subreport ControlSource
    ... You can set your subreport's record source to a saved query. ... You would then run some code prior to opening ... >> This should be done prior to the main report opening. ...
    (microsoft.public.access.reports)
  • Re: Autonumber needed in form when new record opens
    ... > frustrating. ... >>> SQL database with Access Project ... can you update records in it? ... >> query? ...
    (microsoft.public.access.modulesdaovba)
  • Re: using a field from a querry in some VBA code on a form
    ... DLookup() should return an answer without opening the query for the user to ... > Minimize the querry and run my Error message if needed. ...
    (microsoft.public.access.queries)
  • Re: Add field to the table in the backend
    ... I see no reason that would prevent you from simply opening up the back end, ... often adding new updates, bug fixes, new reports, and on the ocation, also ... For example often people build a form using the wizard, and a query. ... of course if you're in a different location, or don't have physical access ...
    (microsoft.public.access.modulesdaovba)