Results 1 to 3 of 3
  1. #1
    SunTop is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Aug 2016
    Posts
    93

    backup version compare

    Hello everyone,



    I have a database that I make regular backups for and now I need to compare the changes in data between two versions. I searched in google and found a utility that compares the deign changes between two versions of a database, but I want to compare the actual data not the design changes, sure I can create some elaborate query to do that, but if their is a tool out their that does this, why re-invent the wheel, does anybody know a tool or a utility that will safe me some time and compare the data in two versions of a database backup files ?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,527
    Link in the tables from the backup,make an outer join to see the differences.

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,981
    Quote Originally Posted by ranman256 View Post
    Link in the tables from the backup,make an outer join to see the differences.
    That will certainly do part of the task in identifying records added or deleted.
    To see where individual fields have been altered will need a lot more work.

    Not aware of a utility that can do this but others may know better
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 7
    Last Post: 02-05-2018, 08:14 PM
  2. Replies: 6
    Last Post: 02-18-2016, 10:15 AM
  3. Replies: 4
    Last Post: 05-30-2012, 07:00 AM
  4. Replies: 5
    Last Post: 01-18-2012, 12:46 PM
  5. Ezy BackUp
    By FogLine in forum Programming
    Replies: 0
    Last Post: 07-04-2010, 06:46 PM

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