Solved

recordset not updateable with Access query to linked Sql Server table

Posted on 2013-10-28
3
449 Views
Last Modified: 2013-10-30
I'm getting the error "Recordset not updateable"

dbo_Part_Serial_Number is a Sql Server table

My query in Access:
SELECT dbo_Part_Serial_Number.ID, dbo_Part_Serial_Number.Part_No, dbo_Part_Serial_Number.Serial_No, dbo_Part_Serial_Number.Label_Date, dbo_Part_Serial_Number.PCBoard_Lot_No1, dbo_Part_Serial_Number.PCBoard_Lot_No2, dbo_Part_Serial_Number.PCBoard_Lot_No3, dbo_Part_Serial_Number.PCBoard_Lot_No4, dbo_Part_Serial_Number.PCBoard_Lot_No5, dbo_Part_Serial_Number.Transformer_Lot_No1, dbo_Part_Serial_Number.Transformer_Lot_No2, dbo_Part_Serial_Number.Transformer_Lot_No3, dbo_Part_Serial_Number.Transformer_Lot_No4, dbo_Part_Serial_Number.Multiplier_Lot_No1
FROM dbo_Part_Serial_Number
WHERE (((Left([Part_No],1))="P"))
ORDER BY dbo_Part_Serial_Number.Label_Date DESC;

Teach me more experts!
Thanks,
Brooks
0
Comment
Question by:gbnorton
3 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 350 total points
ID: 39606576
does the table has a primary key?
it needs to have one for access to be able to update
0
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 150 total points
ID: 39608240
Expanding on momi_sabag's comment, when you linked the SQL Server table to Access, the Access linked table wizard would have asked you what the primary key is for that table.  If you do not supply that, then Access will not be able to write updates to the SQL Server table.
0
 

Author Closing Comment

by:gbnorton
ID: 39612005
It did not.  Added primary key to original Access table and re 'upsized' to sql server.  All good now.  Thank you!
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question