Results 1 to 4 of 4
  1. #1
    Join Date
    May 2008
    Posts
    3

    Unanswered: Problems with deleting a post in Access 97

    Hi people.
    I wonder if you can help me with this one, i have tried deleting a post both in the form view and in the table view, in both cases it quits the program without a single reason.

    Each post consists of a "notepad" field where there has happened a #fault error, i checked and corrected 35 of these #fault errors yesterday (deleting and add again), without problems but this last one is not deletable. I tried searching your forums but i couldnt find anything like it.

    I've also tried a SQL sentence deleting the post resulting in the same error.

    Happy for help.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Can you post your table DDL and the SQL you have tried please.
    George
    Home | Blog

  3. #3
    Join Date
    May 2008
    Posts
    3
    Im fixing this another way by copying the whole table into a new database, but thanks for the help

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Probably the best course of action tbh; it sounds like corruption to me.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •