Results 1 to 3 of 3
  1. #1
    Bonnie is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    1

    Missing 3000 records - when transferred from 2007 access to 2016 access -- same data backup - help


    I am updating from 2007 access to 2016 - new computer - the data on the old computer running access 2007 has 13057 records -- when I transfer the front end and the data to the new computer and 2016 access -- the records stop at 10250 -- HELP! We are a non profit, all volunteer food pantry - and need help. Thank you!

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,964
    Not really enough info to make an real suggestions. Can you transfer back again and then run an unmatched query to see what is missing? - perhaps that will tell you why. Also, how did you transfer the data? just copy the file across or some sort of import or export routine? Perhaps you copied a backup across rather than the live file? Are you sure your record count is correct - no duplicates etc?

  3. #3
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Another possibility -

    Are you sure the actual number of records has changed, and not just the maximum value in an autonumber field? Depending on how you did the transfer, the values in an Autonumber fields might be reset, which in turn could lead to all kinds of problems if you use those fields in relationships.

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

Similar Threads

  1. Replies: 1
    Last Post: 04-18-2016, 01:33 PM
  2. MsysDb file missing in -Access 2007
    By danvadis in forum Forms
    Replies: 1
    Last Post: 03-15-2016, 06:44 AM
  3. context help in VBA editor in Access 2007 is missing
    By OlivierStikkelman in forum Programming
    Replies: 3
    Last Post: 06-25-2014, 10:03 AM
  4. Replies: 4
    Last Post: 10-10-2013, 01:59 PM
  5. Missing .mdw file for inherited MS Access 2007 DB
    By NewMexicoNovice in forum Security
    Replies: 4
    Last Post: 05-07-2013, 01:55 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 - Senior Forums