Wanting to delete/edit rows - Support Queries - myLittleTools Community Forum

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » Wanting to delete/edit rows

Wanting to delete/edit rows

Options · View

Previous Topic · Next Topic

kiwigeordie

Posted: Wednesday, March 04, 2009 10:03:10 PM

Rank: Newbie
Groups: Member

Joined: 3/4/2009
Posts: 2
Points: 6
Location: NZ

Newbie here.
I'm trying to remove some records from various tables in my database, but have noticed that some tables will allow this, while others won't - as there are no icons to allow this at the start of the row. This is a database (and app) that I've "inherited" from someone else and it was they who set up the database (honest! smile

). Would this be a setting somewhere in the SQL setup?
If so, is there any danger attached to making them all editable?

TIA.

kiwigeordie

Posted: Thursday, March 05, 2009 12:58:03 AM

Rank: Newbie
Groups: Member

Joined: 3/4/2009
Posts: 2
Points: 6
Location: NZ

I discovered it was because of the lack of an Index in the tables.
The ones I could not edit had been created via an export from MS Access.

elian

Posted: Friday, March 06, 2009 2:11:21 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

A lack of Primary Key to be exact.

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » Wanting to delete/edit rows

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.