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.
"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.
provides instructions for older versions with a connection string
.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"
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.