Hi,
I'm trying to convert an Access file to an Access Project (Upsize the tables to SQL Server). Some errors prevent me from upsizing my query so I am trying to copy queries from the old .mdb file to the new .adp file.
One of my query in .mdb file has this in the criteria:
[Forms]![frm_1]![txtBox].[Value]
SQL:
where (tbl_1.chn) = [Forms]![frm_1]![txtBox].[Value]
This line of code does not work in the .adp file. And the query in .adp file automatically add a " N'...' " so the code looks like:
where chn = N'[Forms]![frm_1]![txtBox].[Value]'
Does anyone have an idea of what might be wrong? Is the expression correct for query in Access Project?
Thanks - YG
I'm trying to convert an Access file to an Access Project (Upsize the tables to SQL Server). Some errors prevent me from upsizing my query so I am trying to copy queries from the old .mdb file to the new .adp file.
One of my query in .mdb file has this in the criteria:
[Forms]![frm_1]![txtBox].[Value]
SQL:
where (tbl_1.chn) = [Forms]![frm_1]![txtBox].[Value]
This line of code does not work in the .adp file. And the query in .adp file automatically add a " N'...' " so the code looks like:
where chn = N'[Forms]![frm_1]![txtBox].[Value]'
Does anyone have an idea of what might be wrong? Is the expression correct for query in Access Project?
Thanks - YG