Hey All,

I am fairly new to the VB world. Am trying to do a simple insert statement using VB and got this error message .. Can't Update. Database or object is read-only. error number 3027.

Running on VB 5 and SQL Server 7. Works fine with Access though. Attached below is a sample code that I am using. Any help will be greatly appreciated. Thanks a million.


Dim myDB As Database
Dim testTable As Recordset

Set myDB = OpenDatabase(recbooks, False, False, "database=recbooks;uid=sa;pwd=;dsn=connectionString")
Set testTable = myDB.OpenRecordset("narratorInfo")
With testTable
.AddNew
!lastname = "duh1"
!firstname = "duh1"
.Update
End With