Results 1 to 2 of 2
  1. #1
    sivajihero is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    Feb 2016
    Posts
    1

    updating one table with the value of another table and the two tables are in seperate database

    I have two tables in my two databases. The two tables columns are same. So I need to update table1 data to table2. But the two tables are in two databases.


    Currently I have the query to update data in the same database.






    UPDATE Table1 INNER JOIN Table2 ON Table1.CODE = Table2.CODE
    SET Table1.Marks = [Table2].[Marks];


    This query is successfull in the same database. But Now I have two databases in location MyDocuments in C.
    Database1 and Database2. So How can I do it two databases, update Table1 data from Database1 to Table2 in Database2 .

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    In the database where you want this Update Query to run, create a linked table to the table in the other database. Then you can use it as if it existed in the database you are working in.

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

Similar Threads

  1. Replies: 2
    Last Post: 12-04-2015, 08:30 AM
  2. Replies: 25
    Last Post: 04-03-2014, 02:04 PM
  3. Replies: 2
    Last Post: 11-12-2013, 12:50 PM
  4. Replies: 2
    Last Post: 07-07-2011, 08:25 AM
  5. Updating Table Croupt's the database
    By saqibawr in forum Forms
    Replies: 1
    Last Post: 01-11-2011, 04:09 PM

Tags for this Thread

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