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 Anonymous user

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions