Read-only users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bigitch - 17 Apr 2006 02:24 GMT

I don't have very detailed needs for user security, but occasionally want a
particular user to be able to look at the database only, with no mod
capability. Made a security group with read-only priveleges . . .problem is,
one lookup drop-down does a Record Save before loading and displaying the
selected record. The read-only users get an error on that function, and can't
continue. Which security setting would I change to allow that, but not allow
any other changes to the data.

Reply to this Message

Joan Wild - 17 Apr 2006 18:14 GMT

Why is a record save necessary on a combobox that 'finds a record'?

Signature

Joan Wild
Microsoft Access MVP

> I don't have very detailed needs for user security, but occasionally
> want a particular user to be able to look at the database only, with
[quoted text clipped - 3 lines]
> on that function, and can't continue. Which security setting would I
> change to allow that, but not allow any other changes to the data.

Reply to this Message

bigitch - 17 Apr 2006 19:50 GMT

I typically do that to ensure a save if they forget to "save" the record
before finding another record. . .

> Why is a record save necessary on a combobox that 'finds a record'?
>
[quoted text clipped - 5 lines]
> > on that function, and can't continue. Which security setting would I
> > change to allow that, but not allow any other changes to the data.

Reply to this Message

Joan Wild - 17 Apr 2006 19:55 GMT

It isn't necessary to save a record on a bound form in Access. By
eliminating that, you won't have the problem for read-only users.

Signature

Joan Wild
Microsoft Access MVP

> I typically do that to ensure a save if they forget to "save" the
> record before finding another record. . .
[quoted text clipped - 13 lines]
>>> setting would I change to allow that, but not allow any other
>>> changes to the data.

Reply to this Message