Results 1 to 2 of 2

Thread: openRecordset to update database???

  1. #1

    Thread Starter
    Member
    Join Date
    Apr 1999
    Posts
    39

    Post

    Please can anyone tell me when i open the recordset in the following way why does it not let me update the database? how can i amend this?

    Set WrkOdbcx = createWorkspace ("NewODBCWorkspace", "", "", dbUseODBC)
    ConString = "ODBC;Database= PIMS_SQL ;DSN=sqlPims" WrkOdbcx.OpenDatabase("pims_sql", False, False, ConString)

    Set rsAddresses = DbODBC.OpenRecordset("select * from customer", dbOpenDynaset, False)

    // with above code I can not edit like
    rsaddresses.edit //this gives me that //database is read only but thats not true

  2. #2
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105

    Post

    The options parameter (third value in the openrecordset statement, you're using "false") is optional, try running without it.

Posting Permissions

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



Click Here to Expand Forum to Full Width