Results 1 to 6 of 6
  1. #1
    ondrejruz is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2022
    Posts
    16

    update table in another access mdb file

    Hello. Can anyone help? I have an updated tableX in access file1. I would need to transfer those records to access file2.
    I imagine it in the way that I read tableX in file1, I read file2 with the key and if the key is the same, I do UPDATE to tableX in file2,
    if there is no such key, I do APPEND to tableX in file2.


    Is it possible to do it somehow in Access? If so, in what way...
    Ondrej

  2. #2
    xps35's Avatar
    xps35 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    229
    Why store data at two places?

    Make a linked table in file 2 linking to the table in file 1.
    Groeten,

    Peter

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    In file 1, link to the table in file 2. Then run your update and append queries.
    Or you may be able to combine these into one query. See UpEnd Query (isladogs.co.uk)

    Alternatively, avoid duplication. Just use the table in file 1 and make that a linked table in file 2.
    Even better, put tableX in a backend file and link to that from both file 1 & file 2

    EDIT Too late, didn't see the previous answer before posting
    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

  4. #4
    ondrejruz is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2022
    Posts
    16
    Hello. File1.mdb is on one PC at home, where I do updates. File2.mdb is on another PC. TableX has the same structure on both PCs. Ondrej

  5. #5
    xps35's Avatar
    xps35 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    229
    Make split databases of both files. After updating file1 replace the back end of file2 with file1's back end.
    Groeten,

    Peter

  6. #6
    ondrejruz is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2022
    Posts
    16
    well thank you

    Ondrej

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

Similar Threads

  1. Excel Template File to Add/Update Access Backend Table
    By stildawn in forum Import/Export Data
    Replies: 3
    Last Post: 05-05-2020, 09:49 AM
  2. Export Access table data to flat file (txt file)
    By edmscan in forum Import/Export Data
    Replies: 3
    Last Post: 06-17-2015, 12:03 PM
  3. Update Table Based on External File
    By 2tMonte in forum Import/Export Data
    Replies: 6
    Last Post: 02-05-2013, 07:20 PM
  4. VBA to update Products Table from excel file
    By Mclaren in forum Programming
    Replies: 2
    Last Post: 07-26-2012, 12:14 AM
  5. How to update table if linked ot text file
    By cory_jackson in forum Import/Export Data
    Replies: 7
    Last Post: 01-03-2012, 03:19 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