Strange problem with permissions

  • Thread starter Thread starter Stephanie
  • Start date Start date
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.
 
Try adding a TimeStamp Field in the SQL Table.

A TimeStamp Field "upsize_ts" is recommended when Access Tables are upsized
to SQL Server. I am not sure what the TimeStamp Field does but Access FEs
seem to like it, possibly, the TS Field keeps track of Records being
processed / edited.

My experience is more with Access MDBs using ODBC-linked Tables from SQL
Server. I had some strange errors when I didn't use the TS Field and hardly
any problem since I use the TS Field. It may be a coincidence, though.
 
Back
Top