I have an Access database that is linked to a SQL back-end. It runs slow. I checked some things you guys gave in a prior post. Now, I have created a new database and imported everything into it. I had to go through and add 4 References to match the old DB. Nothing else changed. It is updating from the SQL back-end. It has an Autonumber field linked to a number field. Here is the Access SQL for the query. However, one of my queries is now not updatable.
START OF QUERY
UPDATE tblRecommendationsView INNER JOIN tblDropWaiverStatus ON tblRecommendationsView.WaiverStatusID = tblDropWaiverStatus.WaiverStatusID SET tblRecommendationsView.RecommendationNote = [RecommendationNote] & Chr(13) & Chr(10) & "Waiver Status: " & [tblDropWaiverStatus].[WaiverStatus]
WHERE (((tblRecommendationsView.WaiverStatusID) Is Not Null));
END OF QUERY
Is there something that I need to import to make this work? Or, is there something else I am missing?
START OF QUERY
UPDATE tblRecommendationsView INNER JOIN tblDropWaiverStatus ON tblRecommendationsView.WaiverStatusID = tblDropWaiverStatus.WaiverStatusID SET tblRecommendationsView.RecommendationNote = [RecommendationNote] & Chr(13) & Chr(10) & "Waiver Status: " & [tblDropWaiverStatus].[WaiverStatus]
WHERE (((tblRecommendationsView.WaiverStatusID) Is Not Null));
END OF QUERY
Is there something that I need to import to make this work? Or, is there something else I am missing?