Iam trying to run the following code. I have administrator rights on the db and for good measure have added my user to have full rights but get the above error. Any other ideas apart from a permissions thing ?
Thanks
It works when I run it against the same tables on a SQL Server using Query Analyzer
tsql2 = "UPDATE Local_IA_CUR SET NonBillHrsMktg = (SELECT Local_IA_CUR_MKTG.NonBillHrsMktg_dw"
tsql2 = tsql2 & " FROM Local_IA_CUR_MKTG WHERE Local_IA_CUR.mttk = Local_IA_CUR_MKTG.mttk)"
DoCmd.RunSQL (tsql2)
Thanks
It works when I run it against the same tables on a SQL Server using Query Analyzer
tsql2 = "UPDATE Local_IA_CUR SET NonBillHrsMktg = (SELECT Local_IA_CUR_MKTG.NonBillHrsMktg_dw"
tsql2 = tsql2 & " FROM Local_IA_CUR_MKTG WHERE Local_IA_CUR.mttk = Local_IA_CUR_MKTG.mttk)"
DoCmd.RunSQL (tsql2)
Last edited: