Hello,
I would like to update one access table from another access table.
There are no primary keys nor other calculated fields.
The column definitions are all the same in both columns, only the values are different in some cases.
Sadly I can't delete the old database and use the new one, because multiple users are using it at the same time. (It is locked).
My first try did look like something like this:
UPDATE STDLIB_EANCU000DH
SET
EANLAN = EANDU000.EANLAN,
EANBBN = EANDU000.EANBBN,
... (70+ other columns)
Access wants that I enter some Parameter values but I thought it gets the data from the other one.
(One table is named: EANDU000 the other is STDLIB_EANCU000DH.)
Then on my second try I did choose the "append" Option. This didn't work because the database is bigger than 2 gb.
Are there other Options to merge two databases with the same fields?
I'm using Access 2013.
Kind regards
Kevin