delete on linked table failed

[RaineSpencer]

Hi,
I have an access 2000 database with SQL 2000 back-end. I cannot delete from one table using Access.

I get ODBC- delete on linked table xxx failed
[Microsoft][ODBC SQL Server Driver][SQL Server]
DELETE permission denied on object xxx, database xxx, owner DBO (#229)

I can delete the record directly from within SQL
I can update the problem table, edit the problem table from access with no trouble.
I am admin in access, all rights to table that is the problem
I have re-linked the table, no change
I have all permissions on table in SQL

I am stumped.

 

[RaineSpencer]

Never mind. I finally found the problem. I have group membership in two different groups (forgot completely about one), and one group had rights and one didn't.