Hello,
I use a small FRENCH Access database which is sync on my two computers via googledrive.
In an update query, I have a windows error "DlookUp function not defined in the expression"
This error is displayed only on my laptop. On my livingroom computer, the database is OK.
Table1
fieldOne |
fieldTwo |
fieldThree |
mycache |
1234 |
5678 |
Query1 (RechDom is the french for dlookup)
Code:
RechDom("[fieldTwo]";"Table1";"[fieldOne]='mycache'")
Here is the SQL code
Code:
UPDATE Table2 SET Table2.champ2 = DLookUp("[fieldTwo]","Table1","[fieldOne]='mycache'");
Do you know where is the problem?
Thanks a lot for your help.