Users Cannot Add/Del/Modify Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Users of my application cannot add/del/modify records via forms despite my having given them permission to do so under workgroup security. They can do so if they open a table, rather than work through the switchboard, etc. What have I missed?
 
The first thing I would check would be the Data Properties of each of the
affected forms. The following properties should be set to Yes:

Allow Edits
Allow Deletions
Allow Additions

Also check to see that the RecordSet Type is not set to Snapshot.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Jo Anne said:
Users of my application cannot add/del/modify records via forms despite my
Click to expand...
having given them permission to do so under workgroup security. They can do
so if they open a table, rather than work through the switchboard, etc.
What have I missed?
 
Thanks for the quick reply! All of the forms, etc allow edits, deletes, editions and the RecordSet Type is Dynaset. Any other suggestions?
 
Can you be more specific.

There is no add/modify/del permissions for a form.

What is the recordsource for the form. What permissions do they have for
the recordsource and for the form?

--
Joan Wild
Microsoft Access MVP

Jo Anne said:
Thanks for the quick reply! All of the forms, etc allow edits, deletes,
Click to expand...
editions and the RecordSet Type is Dynaset. Any other suggestions?
 
I set up each user to have view, create, add and del rights on all tables, queries, forms, etc in Workgroup Security. Per Cheryl Fischer's sugsestions, I checked that each form allowed edits, deletions, and additions.

----- Joan Wild wrote: -----

Can you be more specific.

There is no add/modify/del permissions for a form.

What is the recordsource for the form. What permissions do they have for
the recordsource and for the form?

--
Joan Wild
Microsoft Access MVP

Jo Anne said:
Thanks for the quick reply! All of the forms, etc allow edits, deletes,
Click to expand...
editions and the RecordSet Type is Dynaset. Any other suggestions?
 
Jo Anne said:
I set up each user to have view, create, add and del rights on all tables,
Click to expand...
queries, forms, etc in Workgroup Security.

But the thing is, you *can't* set create, add, del rights on a form (and
there is no permission called 'view')
Per Cheryl Fischer's sugsestions, I checked that each form allowed edits,
Click to expand...
deletions, and additions.

Is your database split into FE/BE?
 
Jo Anne,

Another thing that you might want to check is just what the record source of
your form is. If it is a query, is the query updatable? A quick and dirty
way to check this is to run the query outside of your form if it is a saved
and named query and try to make a change to some item of data in it. If you
cannot make a change in the query's results, then your users will not be
able to do so in the form. If you are using a SQL string as the record
source, you can click the button with the three little dots that is found at
the right edge of the form's record source property. This will show a Query
Design for that SQL string. You can run the query from there and see if it
is updatable.

All of the above is another way of saying that you can set the RecordSet
Type as Dynaset and grant appropriate security, but if you are using a query
as the RecordSource of your form, the query itself must be updatable for
changes to be made.

For the moment, that is the only additional thing I can suggest as a cause
that is not related to Access Security.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Jo Anne said:
I set up each user to have view, create, add and del rights on all tables,
Click to expand...
queries, forms, etc in Workgroup Security. Per Cheryl Fischer's
sugsestions, I checked that each form allowed edits, deletions, and
additions.
 
I'm referring to the read, update, insert and delete items in User and Group Permissions under security.
 
Jo Anne

I know what you are referring to, but open that dialog. You will see that
the only valid permissions you can set for a form are:

Open/Run
Read Design
Modify Design
Administer

The other permissions do not apply to a form (only tables/queries).

You need to be more specific on the settings you have in order for us to
help you.

What is the record source for the form - a query, a table, a SQL statement,
what?

What permission(s) do your users have on this recordsource?

What permission(s) do they have on the form?

Is your database split?

--
Joan Wild
Microsoft Access MVP

Jo Anne said:
I'm referring to the read, update, insert and delete items in User and
Click to expand...
Group Permissions under security.
 
Sorry, I guess I wasn't sure if you realized what I was asking about

The record source is a Query
The users' permissions for the query are Read/Design, Read, Update, Insert, Delete
The users' permissions for the form are Open/Run
The database is not split
 
Is the query set to RWOP (run with owner permissions); and does the owner
have full permissions on the tables that the query is based on?

OR

What permissions do the users have on the tables that the query is based on.

What message do the users get when they attempt to open the form and/or
add/delete/edit using the form?
 
Back
Top