ACCESS 2010 Update Query Not Working

mercredi 18 février 2015

Trying to perform a basic update query; tables reside in two different databases. Has been working for weeks and today, it doesn't work. As of today, I get a "Enter parameter value" which does not make since to me. :banghead::banghead::banghead: See below



I've attached screen shots. Is there an issue with 2010 Access that is causing this? How can I get around it?



ADDED:

To make this more interesting, when I change it to a SELECT query, I'm able to update the records. Not sure why it stopped working but please note -



SELECT QUERY

SELECT DISTINCTROW Issues.Description, [TBL003_Combined Data].[ISSUES DESCRIPTION], Issues.Comments, [TBL003_Combined Data].[REF ID], Issues.[Store Number], [TBL003_Combined Data].NOTES

FROM [TBL003_Combined Data] INNER JOIN Issues ON [TBL003_Combined Data].[DARKO CS REF #] = Issues.ID;



UPDATE QUERY

UPDATE DISTINCTROW [TBL003_Combined Data] INNER JOIN Issues ON [TBL003_Combined Data].[DARKO CS REF #] = Issues.ID SET Issues.Description = [TBL003_Combined Data].[ISSUES DESCRIPTION], Issues.Comments = [TBL003_Combined Data].[REF ID], Issues.[Store Number] = [TBL003_Combined Data].[NOTES]

WHERE (((Issues.Description) Is Null));




ACCESS 2010 Update Query Not Working

0 commentaires:

Enregistrer un commentaire

Labels