Very Computer

1. RecordSet Edit Method

Hi guys!  Here's one for ya...  I'm getting an error
when the rstemp.edit code gets ran.  It's saying that
the recordset or database has been opened as
read only (Error 3027).  But, as you can see, the Readonly option
is set to False, and the Recordset Type is set to dbOpenDynaset.
The only thing that I can think of is that the SELECT statement has
a JOIN in it...  This shouldn't matter though, right?  Also, I'm logged
into the database as SA with full priveleges...  Any help would be
very appreciated.  Thanks!  Scott

    SQL = "SELECT  c.icompanyid, c.vchcompanyname, c.vchphonenumber, "
    SQL = SQL & "cty.chCountryDesc, c.vchcity, cty.chphonemask "
    SQL = SQL & "FROM     company c, country cty "
    SQL = SQL & "WHERE    c.vchcountrycode = cty.chcountrycode "
    SQL = SQL & "ORDER BY c.iCompanyid"

    Set dbs = OpenDatabase(sDatabasename, False, False, sConnect)
    Set rsTemp = dbs.OpenRecordset(SQL, dbOpenDynaset, dbSeeChanges)

    rsTemp.MoveFirst
    Do Until rsTemp.EOF

        If rsTemp!iCompanyid = "24464" Then
            rsTemp.Edit
            rsTemp!vchPhonenumber = "12345000678923"
            rsTemp.Update
            Exit Sub
       End If

        x = x + 1
        lblComplete.Caption = x
        lblComplete.Refresh
        rsTemp.MoveNext
        DoEvents

    Loop

2. convert .prg files to SQL

3. Recordset Edit method...

4. Another question about "Failed to enlist error"

5. DAO 3.5, SQL recordset won't allow edit method

6. SQL Lead Programmer Wanted / Chicago, IL

7. Help:Editing field values of an ADO recordset returned from SQL SP

8. SQL7 Database Security

9. Help: Editing field values of ADO recordset from SQL db

10. Editing a field value in a ADO Recordset

11. edit an ado recordset using datagrid

12. ADO Recordset has no edit method like DAO Recordset - HELP!