Access 2010 to SQL server 2014 for updateable recordset

Trying to create an updatable form in Access 2010 connected to sql server 2014. I Don't want to use linked tables as many results will be provided by stored procedures. Using
"Provider=SQLOLEDB;SERVER=MYPC\DEV2014;Initial Catalog=Northwind;Integrated Security=SSPI" will open and connect an ADO recordset and use as a recordsource for a form.

The form will display all records but does not allow edits.

https://support.microsoft.com/en-us/help/281998/how-to-bind-microsoft-access-forms-to-ado-recordsets provides instructions for older versions with a connection string With cn .Provider = "Microsoft.Access.OLEDB.10.0" .Properties("Data Provider").Value = "SQLOLEDB" .Properties("Data Source").Value = "MySQLServer" .Properties("User ID").Value = "sa" .Properties("Password").Value = "" .Properties("Initial Catalog").Value = "Northwind" .Open End With For Access 2010 i can use .Provider = "Microsoft.ACE.OLEDB.12.0" but it Errors on "Data Provider" item cannot be found in the collection.

0
edit delete
are you sure?
asked unknown

3 answers

Love your blog man. Thanks for this stuff. https://iapptoko.com https://v-share.org https://ppssppgoldapk.co

0
edit delete
are you sure?
answered ios man

The author has made a mind-blowing article. You made your point and no to take a gander at. It takes after this the whole thing taken into consideration noticed validation that you can not combat the reality of the problem isn't wide, the whole thing has its amazing case. A dedication of appreciation is all together for this statistics. Go To Our Website at Essay Bird | https://www.essaybird.co.uk

0
edit delete
are you sure?
answered Jam Martin

Everything apps from the official market are set up on top of the synchronization of services respectively default. And then through this program you newtypes to deconstruct fully any application. Turning off (for other things, the aforesaid patcher allows you to reject advertising from any downloaded games still utilities. https://filmsapk.com/lucky-patcher-apk/

0
edit delete
are you sure?
answered Evgeni Igorevich

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions