I have the following query:
It works in Access but not through ADO updating an Access database. Any ideas?
Thanks.
Swi
Code:
conn.Execute "UPDATE [Master] SET [Master].[Estimated_Delivery_Date] = [Master].[Estimated_Delivery_Date] + 1 WHERE WeekDay([Master].[Estimated_Delivery_Date]) = 1"
It works in Access but not through ADO updating an Access database. Any ideas?
Thanks.
Swi