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
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