Results 1 to 3 of 3
  1. #1
    greatwhite is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Location
    Ottawa, ON
    Posts
    56

    MS Access stored query roll back if unsuccessful


    OK So I have a bunch of import queries to run to import old data into the new system. However last time I ran these I found some issues with the data and had to do some clean up, Fast forward 3 months later it appears I did not keep any notes on the data.

    So in MS Access is it possible to roll back an unsuccessful insert statement? I'm guessing no but I thought I would ask.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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
    greatwhite is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Location
    Ottawa, ON
    Posts
    56
    Thanks, that's what I ended up doing

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

Similar Threads

  1. Crosstab Query - Roll up Row Headings to one row
    By wmmcpherson in forum Queries
    Replies: 2
    Last Post: 08-22-2018, 03:01 AM
  2. Replies: 3
    Last Post: 08-18-2014, 09:19 AM
  3. Replies: 2
    Last Post: 08-21-2012, 02:38 PM
  4. Roll up costs with vba
    By nigelbloomy in forum Programming
    Replies: 1
    Last Post: 07-31-2012, 01:03 PM
  5. Calling Stored Proc in MS Access 2007 without creating query?
    By DistillingAccess in forum Programming
    Replies: 1
    Last Post: 08-03-2010, 09:38 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