Results 1 to 7 of 7
  1. #1
    soco3594 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2015
    Location
    Australia
    Posts
    20

    Deleted records not actually deleted

    Hi guys,



    I tried doing a search on this but couldn't find exactly what I was after. I have a fairly basic form which allows users to add, delete and navigate between different purchase orders.

    When I click the delete button, Access displays the message "You are about to delete 1 records(s) etc..." and I click yes and close the form. When I reopen the form or open the table however, the record still exists...

    Any thoughts?

    Cheers

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Would have to review table structure and form design. If you want to provide db for analysis, follow instructions at bottom of my post.

    Deleting records should be a rare event.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    soco3594 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2015
    Location
    Australia
    Posts
    20
    I can't seem to compress the file below 2mb... I'm thinking it's an issue with how my tables are linked, will work on it a bit more and see how I go

  4. #4
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    suggest post the code behind the delete button - chances are you have suppressed error reporting and there is an error in the delete sql or code or alternatively you are trying to delete a primary record in a one to many relationship and not deleting the child records first.

  5. #5
    soco3594 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2015
    Location
    Australia
    Posts
    20
    I've stripped out the database and attached:

    Project Management Database_Copy.zip

    If you go into the "Variations" form and try to delete a record, the record still exists when you reopen the form...

    Thanks

    EDIT: I'm relatively new to VBA and still in the process of converting macros to VBA in this particular database so go easy on me

  6. #6
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    the recordsource for your variations form is the problem - it just need to be tblvariations

  7. #7
    soco3594 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2015
    Location
    Australia
    Posts
    20
    Aha! I knew it had to be something simple. Always the trouble when you spend too long looking at something...

    Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. ##deleted records##
    By FJM in forum Access
    Replies: 5
    Last Post: 10-23-2013, 08:08 AM
  2. Replies: 1
    Last Post: 04-12-2013, 04:41 PM
  3. Remove deleted records
    By amerifax in forum Access
    Replies: 4
    Last Post: 10-17-2012, 03:26 AM
  4. delete query produce #deleted in all deleted values
    By learning_graccess in forum Queries
    Replies: 2
    Last Post: 03-31-2012, 07:20 AM
  5. Log Data Changes and Deleted records
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 12-31-2010, 12:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums