Go Back   Access World Forums > Microsoft Access Discussion > Access Web

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-15-2019, 10:14 AM   #1
irade92
Newly Registered User
 
Join Date: Dec 2010
Posts: 164
Thanks: 10
Thanked 0 Times in 0 Posts
irade92 is an unknown quantity at this point
recordset is not updatable

Hi
I export a table to AZURE SQL server. With SSMS I can see that table and everything is ok..I tried to link that table to my desktop aplication with ODBC and again everything is ok until that the recordset is not updatable..I cannot write nor delete a record in that linked table..Any suggestion please?

irade92 is offline   Reply With Quote
Old 01-15-2019, 10:17 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,964
Thanks: 13
Thanked 4,055 Times in 3,991 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: recordset is not updatable

I haven't worked with Azure, but SQL Server tables need a primary key in order to be edited from Access. I'd check that first.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote
Old 01-15-2019, 10:29 AM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,662
Thanks: 38
Thanked 889 Times in 872 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: recordset is not updatable

Hi. You're using the term "recordset." Are you manually opening the table directly from the Navigation Pane and trying to edit or enter data into it and this is not working? If so, I agree with what Paul said about needing a primary key in the table. Otherwise, please tell us exactly what you're doing in Access. If you're using code, please let us see it. Thanks.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 01-16-2019, 07:22 AM   #4
irade92
Newly Registered User
 
Join Date: Dec 2010
Posts: 164
Thanks: 10
Thanked 0 Times in 0 Posts
irade92 is an unknown quantity at this point
Re: recordset is not updatable

Quote:
Originally Posted by pbaldy View Post
I haven't worked with Azure, but SQL Server tables need a primary key in order to be edited from Access. I'd check that first.
You are right...I just missed it ..Thanks
irade92 is offline   Reply With Quote
Old 01-16-2019, 07:47 AM   #5
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,964
Thanks: 13
Thanked 4,055 Times in 3,991 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: recordset is not updatable

Happy to help!

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
This recordset is not updatable Cragproductions Tables 4 01-26-2016 03:06 AM
Recordset Not Updatable rustyg Macros 4 06-18-2010 05:28 AM
recordset not updatable prodigy SQL Server 4 08-30-2006 03:16 PM
Recordset not Updatable Crispy Queries 3 11-15-2005 01:40 AM
Recordset is not updatable? skelley Forms 1 08-16-2000 06:31 AM




All times are GMT -8. The time now is 01:56 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World