Solved

recordset not updateable with Access query to linked Sql Server table

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

939 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now