recordset is not updatable (1 Viewer)

I

irade92

Registered User.

Local time

Today, 12:52

Joined

Dec 26, 2010

Messages

228

• Jan 15, 2019

• #1

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?

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 03:52

Joined

Aug 30, 2003

Messages

36,131

• Jan 15, 2019

• #2

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.

 

theDBguy

I’m here to help

Staff member

Local time

Today, 03:52

Joined

Oct 29, 2018

Messages

21,447

• Jan 15, 2019

• #3

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.

 

I

irade92

Registered User.

Local time

Today, 12:52

Joined

Dec 26, 2010

Messages

228

• Jan 16, 2019

• #4

pbaldy said:

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.

Click to expand...

You are right...I just missed it ..Thanks

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 03:52

Joined

Aug 30, 2003

Messages

36,131

• Jan 16, 2019

• #5

Happy to help!