Recordset is not Updatable
Posted on 1997-11-24
Set mydb = Opendatabase("",false,false,"ODBC;DSN=MSSQLSRV;")
Set Data1.Recordset = mydb.OpenRecordset("test_table",dbOpenDynaset)
Now if I check Data1.Recordset.Updatable , it is false. Why ? mydb.Updatable is True. How can I create an updatable recordset on Data1 without setting the Data Control's Connect and Datasource property. I dont want the Data Control to open a connection of its own to the MS SQL Server 6.5 I have also tried Dim rs as Recordset but even rs turns out to be Updatable False.