Post reply

Cannot delete/update record

  • October 16, 2003 at 1:14 pm

    #83138

    Hi!

    I have a problem with some records in a SQL Server 7 table. There is a block of records that I cannot update or delete (with Enterprise Manager or Access).

    All other records can be updated/deleted and all records are returned in queries. The table does have a primary key.

    Any suggestions anyone?

    Regards,

    Marco

  • October 16, 2003 at 1:22 pm

    #478538

    Any error messages? Foreign key constraint?

  • October 16, 2003 at 1:41 pm

    #478540

    Hi,

    No error messages (in Enterprise Manager), Access responds with timeout expired. No key constraints either.

    Marco

  • October 16, 2003 at 2:14 pm

    #478547

    Check whether there are blocking during the deletion of those records.

Viewing 4 posts - 1 through 4 (of 4 total)

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