S
Stephanie
I have an Access 2002 ADP that points to a SQL 2000 database. The
project is used only for users to open a table and make updates.
There are no forms or queries or special code. They just prefer to
use Access as their GUI instead of Enterprise Manager.
My user is editing a table with about 255 records. He opens the table
and can update 2 or 3 rows and then on the next record he updates, he
gets an error "user does not have permissions to perform this action".
Obviously he does have permission or the first few updates would not
have worked. (I have also verified in the SQL database that he has
full permissions to the table.) He also reports that even though he
receives the message, the update does take.
The problem is hit or miss. Sometimes he updates 1 and then the next
gives an error. The next time he'll update 5 and then get the error
on #6. I checked max rowcount and it is set to 10,000. With less
than 300 records, that should have been fine. I also tried setting
max rowcount to 0. This did nothing to help the problem.
This smells of a buffering or firehose problem, but I've been unable
to find anything that helps.
project is used only for users to open a table and make updates.
There are no forms or queries or special code. They just prefer to
use Access as their GUI instead of Enterprise Manager.
My user is editing a table with about 255 records. He opens the table
and can update 2 or 3 rows and then on the next record he updates, he
gets an error "user does not have permissions to perform this action".
Obviously he does have permission or the first few updates would not
have worked. (I have also verified in the SQL database that he has
full permissions to the table.) He also reports that even though he
receives the message, the update does take.
The problem is hit or miss. Sometimes he updates 1 and then the next
gives an error. The next time he'll update 5 and then get the error
on #6. I checked max rowcount and it is set to 10,000. With less
than 300 records, that should have been fine. I also tried setting
max rowcount to 0. This did nothing to help the problem.
This smells of a buffering or firehose problem, but I've been unable
to find anything that helps.