Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: Up Liftting to Access 2010

Results 1 to 6 of 6
Share This Thread →
  1. #1
    luis baptista is offline Registered User
    Join Date
    Dec 2012
    Posts
    2
    Rep Power
    0

    Exclamation Up Liftting to Access 2010

    I'm convinced that following the conventional unique | autonumbered key fields produces the best relational integrity and thats what I'm persuing
    But how to achieve this when the tables of the previous aplication do support autonumbered key fields, without busting the relational integrity of that previous aplication data base ??
    Any clues other than developing an aplication just migrate data from the old to the new data base ?

  2. #2
    alansidman's Avatar
    alansidman is offline Contributing User
    Join Date
    Feb 2008
    Location
    Lake County, IL
    Posts
    864
    Rep Power
    152
    Create new tables with an autonumber field, and all the other fields from the old db. Run an append query to append all the old data to the new table.
    Alan Sidman
    Office 2010, 2007, 2002

    If I helped you, then click "give rep" button in the lower left corner.

  3. #3
    luis baptista is offline Registered User
    Join Date
    Dec 2012
    Posts
    2
    Rep Power
    0
    Thanks a lot. I'l try just that. But was I clear about the fact that there I'm dealing with several old aplication tables with no autonumbered key fields ?

  4. #4
    alansidman's Avatar
    alansidman is offline Contributing User
    Join Date
    Feb 2008
    Location
    Lake County, IL
    Posts
    864
    Rep Power
    152
    Yes. You were clear. In an append query, if you set your new table with the autonumber, it should populate properly. BTW, I would make a backup of my db before I started any of the updates.

  5. #5
    June7's Avatar
    June7 is offline Moderator
    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,618
    Rep Power
    649
    You will also have to run UPDATE queries to update new foreign key field in dependent tables with the new autonumber primary key. Once everything is properly related on the new fields, the old fk fields can be removed.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.
    Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm

  6. #6
    alansidman's Avatar
    alansidman is offline Contributing User
    Join Date
    Feb 2008
    Location
    Lake County, IL
    Posts
    864
    Rep Power
    152
    @June. Good point. I had forgotten about the FK aspect. A little bit of tunnel vision took over and was thinking only of the PK.

    Alan

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

Similar Threads

  1. Access 2010 Help with merge
    By mrsbeaver in forum Microsoft Access Help
    Replies: 2
    Last Post: October 24th, 2011, 11:36 PM
  2. Access 2010
    By mynorm in forum Microsoft Access Help
    Replies: 1
    Last Post: September 28th, 2011, 07:38 PM
  3. Need HELP with Access 2010
    By iowafarmer in forum Microsoft Access Help
    Replies: 1
    Last Post: June 21st, 2011, 03:28 PM
  4. Vb.net 2010 and Access 2010 and Win 7
    By chuckcb in forum Visual Basic Programming
    Replies: 0
    Last Post: March 14th, 2011, 08:03 PM
  5. Covert access 2010 to access 2007 HELP
    By Hadassch in forum Microsoft Access Help
    Replies: 3
    Last Post: February 23rd, 2011, 02:55 PM

ASP Free Advertisers and Affiliates