I've created a SQL 2005 database from a backup from another system and am writing an application with Access 2003 (as a project) to work with the data. I'm experienced with SQL permissions and programming & Access programming. Users have been able to read data and add it, but I can't enable deleting anything on the production server. On the copy of the database on my development system, I can delete things.
Even logged onto the production systems as me -- the creator of the database, and according to the SQL manager, I'm the owner of the database -- I can't delete data from Access. I can from the SQL Management Studio, though. The behavior is in both converted tables and in a new table I created. Both tables I've tried have primary keys defined on them. The newly created table I've dropped and recreated, but the behavior persists. The behavior occurs both from browsing a table (shown in screenshot) or in SQL code in the application.
Any idea why users can't delete data?