PDA

Click to See Complete Forum and Search --> : openRecordset to update database???


sultan
Aug 19th, 1999, 08:38 PM
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

JHausmann
Aug 19th, 1999, 08:53 PM
The options parameter (third value in the openrecordset statement, you're using "false") is optional, try running without it.