Post reply

MyLittleAdmin

  • March 4, 2009 at 12:27 pm

    #201831

    Newbie here.

    I'm trying to remove some records from various table in my database, but have noticed that some tables will allow this, while others won't. This is a database (and app) that I've "inherited" from someone else and it was they who set up the database (honest! 😛 ). Would this be a setting somewhere in the SQL setup?

    If so, is there any danger attached to making them all editable?

    TIA.

  • March 4, 2009 at 12:30 pm

    #953515

    What error messages are you getting when attempting to delete data?

  • March 4, 2009 at 1:24 pm

    #953549

    I'm not, Lynn.

    I'm simply getting no facility to delete - i.e. there are no icons at the start of the row to do any kind of editing. Some of my other tables have though, but I've no idea how they were created.

    Thanks.

  • March 4, 2009 at 1:31 pm

    #953554

    This sounds like it's better asked at the myLittleAdmin forums: http://forum.mylittleadmin.com/

    I'm wholly unfamiliar with MyLittleAdmin, but I would (wildly) guess the lack of those icons means you lack delete rights on those tables.

  • March 4, 2009 at 1:35 pm

    #953559

    Many thanks for that.

  • March 4, 2009 at 5:59 pm

    #953723

    Discovered it was due to lack of an index on the Tables. The ones I could not edit had been created via an MS Access export.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply