Access : This recordset is not updateable

Hi ,

(I am fairly sure of my diagnostics/conclusions below)

I had a simple form which shows information from 3 tables.
(i..e A MASTER table and 2 joins )

The form has been working fine for weeks but today I added a fourth table (1 field only)
When I added the 4th table my form gave the "Recordset is not updateable message".
I cannot update my table anymore ! Help!
When I remove the 4th table the form fails too as it seems to have lost most of its data (excuse the vagueness)

See code below.
Any thoughts appreciated.

SELECT MASTER.Updates, MASTER.ID, MASTER.COMMENTS, MASTER.LOCATION, MASTER.FILE_BAR, MASTER.FIRST_NAME, MASTER.SURNAME, MASTER.Long_string, MASTER.ADD1, MASTER.ADD2, MASTER.ADD3, MASTER.ADD4, MASTER.SURNAME_2, MASTER.FIRST_NAME_2, MASTER.SURNAME_3, MASTER.FIRST_NAME_3, MASTER.BU_NAME, MASTER.BU_CODE, MASTER.FILE_TYPE, MASTER.FILE_NUM, MASTER.ACTION_1, [BU Names].[Business Unit], MASTER.Last_updated_by, MASTER.SCV_Number, MASTER.NOTES, ALL_fs.Field2 AS [FS Status], Files_Moved_During_Closures.From_To
FROM ((MASTER LEFT JOIN [BU Names] ON MASTER.BU_CODE = [BU Names].BU) LEFT JOIN ALL_fs ON MASTER.FILE_BAR = ALL_fs.Barcode) LEFT JOIN Files_Moved_During_Closures ON MASTER.FILE_BAR = Files_Moved_During_Closures.barcode;

Open in new window

Patrick O'DeaAsked:
Who is Participating?
 
js-profiCommented:
with the statement above you can't find syntax errors. if you would make a fine puryfing you would see that the parantheses were wrongly closed after the third joint.
SELECT MASTER.Updates, MASTER.ID, MASTER.COMMENTS, MASTER.LOCATION, 
       MASTER.FILE_BAR, MASTER.FIRST_NAME, MASTER.SURNAME, 
       MASTER.Long_string, MASTER.ADD1,MASTER.ADD2, MASTER.ADD3, 
       MASTER.ADD4, MASTER.SURNAME_2, MASTER.FIRST_NAME_2, 
       MASTER.SURNAME_3, MASTER.FIRST_NAME_3, MASTER.BU_NAME, 
       MASTER.BU_CODE, MASTER.FILE_TYPE, MASTER.FILE_NUM, MASTER.ACTION_1, 
       [BU Names].[Business Unit], 
       MASTER.Last_updated_by, MASTER.SCV_Number, MASTER.NOTES, 
       ALL_fs.Field2 AS [FS Status], 
       Files_Moved_During_Closures.From_To
FROM ((MASTER LEFT JOIN [BU Names] ON MASTER.BU_CODE = [BU Names].BU) 
              LEFT JOIN ALL_fs ON MASTER.FILE_BAR = ALL_fs.Barcode) 
              LEFT JOIN Files_Moved_During_Closures ON MASTER.FILE_BAR = Files_Moved_During_Closures.barcode;

Open in new window

0
 
jefftwilleyCommented:
You may also benefit by changing the Recordset Property of your query to "Dynaset (Inconsistent Updates)"
J
0
 
Patrick O'DeaAuthor Commented:
ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.