I am editing data. I open up the recordset to "edit" then have a line to Update. I get an error when trying to update. Please help.
Printable View
I am editing data. I open up the recordset to "edit" then have a line to Update. I get an error when trying to update. Please help.
When you created the Recordset, did you create an Updatable one?, ie with OpenKeySet?
If you open a Forward only or Static Recordset you're going to get Errors when trying to perform Edits/Updates.
If not, check the ODBC Properties to make sure you enabled Write Access.
------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]