Re: Renegade Form

The settings won't over-ride permissions. The VBA code you've posted
wouldn't impact it. You'd actually have to change permissions in code for
it to happen. Do you have any code that modifies the form's recordsource,
or changes the SQL of the recordsource?

--
Joan Wild
Microsoft Access MVP
"NevilleT" <NevilleT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ABE6639C-C650-48CE-B335-D833D3A48146@xxxxxxxxxxxxxxxx
Hi Joan
Checked all the above. Let me ask this question. Can any VBA command, or
form settings override the workgroup permissions.

Neville

"Joan Wild" wrote:

Based on the information provided, they would have only read permission.
Double-check each user's permission, as well as 'the' group of interest.

In addition, double-check other groups that the user(s) belong to i.e.
Users
and any other custom groups. You are overlooking something.

--
Joan Wild
Microsoft Access MVP
"NevilleT" <NevilleT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54D9C77A-A19A-4CBB-9CCE-5CC4E0C79CA3@xxxxxxxxxxxxxxxx
I have an application with a number of forms. I can control read only
access
to forms through a group in the workgroup file for all but one form.
The
form uses a query that includes 2 tables.

- The form security is set to Open/Run only
- The query used for the form is set to Read Design and Read Data
- The tables that form the query are set to Read Design and Read Data

I wanted users who are part of this group to only read data. Problem
is
they can modify data on the form. I have checked individual
permissions
for
the users and there are none set. The only odd thing I do with this
form
is
to set some properties depending how it is opened based on a parameter
passed
to it by the particular button used to open it.

NewProjScr = Forms!frmProjectTab.OpenArgs

If NewProjScr = "1" Then
Me.AllowAdditions = True
Me.DataEntry = True
Else
Me.AllowAdditions = False
Me.DataEntry = False
End If

Can anyone suggest why the read only permission is being overridden for
this
form?






.