I have two databases within my project. One has a table created in the database and one is a linked table to another database. I would like the one table to update the other table when they exit the database. The one will be my backup table if someone deletes it by accident or something. So I opened query designer and selected both tables. I then joined them together by selecting the headers and dragging them over to the other table. I then clicked on all the headers in the first table and added them to the field, table, update to, criteria, and or section of the designer. So here is what I put in each of those fields:
Field - Table 1 Header
Table - Table 1
Update To: [table2]![table 2 header]
Did that for each header and then click on run I get an error. The specified field '[ID]' could refer to more than one table listed in the FROM clause of your SQL statement.
If I click on View - Database - I get the following error. Cannot join on Memo, OLE, or Hyperlink object and then lists all the headers from table 2.
Any help or suggestions would be greatly appreciated. Thanks!!
Field - Table 1 Header
Table - Table 1
Update To: [table2]![table 2 header]
Did that for each header and then click on run I get an error. The specified field '[ID]' could refer to more than one table listed in the FROM clause of your SQL statement.
If I click on View - Database - I get the following error. Cannot join on Memo, OLE, or Hyperlink object and then lists all the headers from table 2.
Any help or suggestions would be greatly appreciated. Thanks!!
