We help IT Professionals succeed at work.
Get Started

can't delete data from any tables

GordonPrince asked
Last Modified: 2012-05-12
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? screenshot of error message
Watch Question
This problem has been solved!
Unlock 2 Answers and 6 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE