The following delete query SQL statement working just fine on Access 2003 but after convert to Access 2007, received following message
"Specify the table containing the records you want to delete"
DELETE [Promo].*
FROM [Outlet] INNER JOIN [Promo] ON [Outlet].Out = [Promo].Out;
Please help...
