I create a new connection but I get it as READ-ONLY

  • Thread starter Miguel Angel Diaz via AccessMonster.com
  • Start date
M

Miguel Angel Diaz via AccessMonster.com

Hi, I want acces to a another DB in my sql server so i wrote the code below.

But I get the info as NOT UPDATABLE, as READ-ONLY.

Why?
Can you help? pls

connectStr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TipoCambioSQL;" & _
"Data Source=(local);"
Set cnnNwind = New ADODB.Connection

cnnNwind.Open connectStr

strSQL = "tblTipos"
With rstNwind
.ActiveConnection = cnnNwind
.CursorType = adOpenDynamic
.CursorLocation = adUseClient
.LockType = adLockOptimistic
End With
rstNwind.Open strSQL, , , , adCmdTable

Set Me.Recordset = rstNwind
Me.UniqueTable = "tblTipos"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO Connection Opens as Read Only 2
How to use SQL Server connection string 0
Inserting data into SQL Server table with ADO 2
OWC (office web component ) chart , stacked XY scatter 0
Read-only problem when binding a form to an ADO record source 0
How do you populate Combo Box from ADO recordset? 9
Data Provider Could Not Be Initialized 2
Conexion to SQL Server Express 2008 very slow 4

Top