Results 1 to 5 of 5
  1. #1
    oly is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    18

    Db sync in Ms access

    Dear Experts;



    I have an access db on machine 1 and another access db on machine 2. I need to delete all the contents in the access db on machine 1 and then copy and past the contents of the access db on machine 2 into the access db on machine 1. How do I go about doing so? Thank you

  2. #2
    alcapps is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    292
    sounds like you rename db on machine 1 and copy db 2 to machine 1

    hope this helps..

  3. #3
    oly is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    18
    Quote Originally Posted by alcapps View Post
    sounds like you rename db on machine 1 and copy db 2 to machine 1

    hope this helps..

    no that wouldnt help because the forms are different

  4. #4
    alcapps is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    292
    import the tables.. you can rename the existing tables and import the ones from the other database..

    you could copy the db that has the data you want to a new database..

    then remove all the forms out of the copied database..

    then link the table to your other database..

  5. #5
    oly is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    18
    Quote Originally Posted by alcapps View Post
    import the tables.. you can rename the existing tables and import the ones from the other database..

    you could copy the db that has the data you want to a new database..

    then remove all the forms out of the copied database..

    then link the table to your other database..
    So are you saying the best approach is to import the tables and remane the existing table...if so, how do i go about importing tables in access

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

Similar Threads

  1. Access DB Upgrade Rollout / DB Structural Sync Ideas
    By damientaylorcreata in forum Access
    Replies: 4
    Last Post: 11-25-2012, 08:29 PM
  2. VPN offline Access data sync?
    By Heatshiver in forum Import/Export Data
    Replies: 3
    Last Post: 07-31-2012, 11:20 AM
  3. Replies: 30
    Last Post: 06-26-2011, 10:47 PM
  4. Sync ListBox?
    By rosh41 in forum Forms
    Replies: 4
    Last Post: 06-21-2010, 11:12 AM
  5. Sync table and file in access
    By erlan501 in forum Import/Export Data
    Replies: 1
    Last Post: 04-30-2010, 02:12 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