Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Properties in a RecordSet


Message #1 by Ben Greenhouse <b.greenhouse@u...> on Fri, 09 Mar 2001 10:42:21 -0500
Hi all



    I'm opening a recordset like this:



SQL$ = "Select " & strfields$ & " From "

            SQL$ = SQL$ & tblname$

            SQL$ = SQL$ & " a, CustomerContactPoint b where b.CustomerID

= "

            SQL$ = SQL$ & RS2!CustomerID

            SQL$ = SQL$ & " AND b.ContactPointType = '"

            SQL$ = SQL$ & tblname$

            SQL$ = SQL$ & "' AND b.ContactPointID = a.ContactPointID"

            Set RS3 = DB.OpenRecordset(SQL$)

            RS3.Updatable = True



    I inserted the RS3.Updatable = True line because I was having

problems with the Recordset being read only when I invoked RS3.Edit.

Now it gives me an error saying "can't assign to read-only property".

Why is this recordSet read only?  Any one?  this is driving me nuts...



Ben




  Return to Index