Solved

recordset not updateable with Access query to linked Sql Server table

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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 …
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.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

746 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

11 Experts available now in Live!

Get 1:1 Help Now