What effects updatability?

Results 1 to 2 of 2

Thread: What effects updatability?

  1. #1
    Join Date
    Dec 1969

    Default What effects updatability?

    I opened a recordset with<BR>objRS.open strSQL,objConn,1,2,1<BR>which should be updatable, but the access 97 ODBC driver returns an error saying that it is read-only.<BR>what else could cause this? are there certain SQL statements that cause a recordset to be opened read-only?<BR>thanks,<BR>cory

  2. #2
    lienj Guest

    Default RE: What effects updatability?

    It really depends on what strSQL statement is.<BR>If it&#039;s a simple update then it should look like this:<BR><BR>objRS.Open "update table1 set field1=1 where field1=15", objConn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts