Form permission issue

[AkAlan via AccessMonster.com]

I have developed an adp and now I'm in the process of assigning permissions
to groups but am having some problems. I have a form that has a stored
procedure as a recordsource and I have assigned execute permissions to a
group called manaagers but when they try to update a field the form gives a
message at the bottom that says the recordset is not updatable. I have even
given all permissions to the underlying table and the user can update the
table directly but still not from the form. What am I missing here? Thanks
for any help

 

[Tom van Stiphout]

On Thu, 13 Nov 2008 19:43:40 GMT, "AkAlan via AccessMonster.com"

Is the table itself updatable? That requires at least a Primary Key.

-Tom.
Microsoft Access MVP

 

[Sylvain Lafontaine]

It's not clear from your message if it's only the managers who have a
problem updating the table and other users don't. If your form working when
you are using an account with *full* permission on the database; such as
"sa"?

If not, then make sure that you don't have some incompatible field types
such as BIGINT, some strange numerical or a tri-state bit field.

If everything is OK, then set the UniqueTable and the ResyncCommand
properties of the form.

 

[AkAlan via AccessMonster.com]

The managers group was just the first group I was testing by putting my test
login in their group. I had created the adp a few months ago and at that time
I had used functions for all forms that updated data ( a coworkers method)
and had assigned the recordsource in code in the on load event. I had
qualified the function names with dbo. Now on some new forms I am using
stored procedures to update the data and have since learned about how sql
server 2005 uses schemas instead of owner for all objects. I went in circles
and ended up replacing the sp's with views and playing with the schema
configuration. I did get things to work now think because of the schema
configuration. I do wonder if now the sp's would update the new form and
might try it when I have time. Thanks for your reply.

It's not clear from your message if it's only the managers who have a
problem updating the table and other users don't. If your form working when
you are using an account with *full* permission on the database; such as
"sa"?

If not, then make sure that you don't have some incompatible field types
such as BIGINT, some strange numerical or a tri-state bit field.

If everything is OK, then set the UniqueTable and the ResyncCommand
properties of the form.

I have developed an adp and now I'm in the process of assigning permissions
to groups but am having some problems. I have a form that has a stored

[quoted text clipped - 6 lines]

table directly but still not from the form. What am I missing here? Thanks
for any help

 

[Sylvain Lafontaine]

It's still not clear from your post if you have simply a permission issue
with the managers group or not. The first thing to try would be to test
your form with an account that has full permissions on the database.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

The managers group was just the first group I was testing by putting my
test
login in their group. I had created the adp a few months ago and at that
time
I had used functions for all forms that updated data ( a coworkers method)
and had assigned the recordsource in code in the on load event. I had
qualified the function names with dbo. Now on some new forms I am using
stored procedures to update the data and have since learned about how sql
server 2005 uses schemas instead of owner for all objects. I went in
circles
and ended up replacing the sp's with views and playing with the schema
configuration. I did get things to work now think because of the schema
configuration. I do wonder if now the sp's would update the new form and
might try it when I have time. Thanks for your reply.

It's not clear from your message if it's only the managers who have a
problem updating the table and other users don't. If your form working
when
you are using an account with *full* permission on the database; such as
"sa"?

If not, then make sure that you don't have some incompatible field types
such as BIGINT, some strange numerical or a tri-state bit field.

If everything is OK, then set the UniqueTable and the ResyncCommand
properties of the form.

I have developed an adp and now I'm in the process of assigning
permissions
to groups but am having some problems. I have a form that has a stored

[quoted text clipped - 6 lines]

table directly but still not from the form. What am I missing here?
Thanks
for any help

 

[AkAlan via AccessMonster.com]

I do have a permissions issue with the managers group. I had read that if you
gave certain permissions to a shema they would propogate to all objects
within the schema. I obviously need to do more research because I can go to
each individual object and grant permission to the managers group and they
work ok. I will just have to bite the bullet and do that for now and figure
out how to grant permissions to all objects with one fell swoop later. Thanks
Sylvain once again for your time, you have been a great help to me so many
times, whether directly or through other peoples posts.

It's still not clear from your post if you have simply a permission issue
with the managers group or not. The first thing to try would be to test
your form with an account that has full permissions on the database.

The managers group was just the first group I was testing by putting my
test

[quoted text clipped - 30 lines]

 

[Sylvain Lafontaine]

Sorry but at this moment, I use dbo exclusively - even on SQL-Server 2005 -
so I have no idea what's going on here and I cannot help you any further.

However, I'm surprised by the fact that granted some permissions to a schema
make them propagate to all objects within the schema. This is unexpected to
me and I will have to investigate this when I'll have more time.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

I do have a permissions issue with the managers group. I had read that if
you
gave certain permissions to a shema they would propogate to all objects
within the schema. I obviously need to do more research because I can go
to
each individual object and grant permission to the managers group and they
work ok. I will just have to bite the bullet and do that for now and
figure
out how to grant permissions to all objects with one fell swoop later.
Thanks
Sylvain once again for your time, you have been a great help to me so many
times, whether directly or through other peoples posts.

It's still not clear from your post if you have simply a permission issue
with the managers group or not. The first thing to try would be to test
your form with an account that has full permissions on the database.

The managers group was just the first group I was testing by putting my
test

[quoted text clipped - 30 lines]

Thanks
for any help