Solved

recordset not updateable with Access query to linked Sql Server table

Posted on 2013-10-28
3
448 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 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