A fellow developer and I are experiencing trouble trying to add a record to a table (in VB). We created the table using the user UIB. I am the admin (not a good one mind you since I am a newbie) for the Oracle databases and I don't know if there are privileges that are missing or not, for us to add records. We can open the table data editor in the schema manager that comes with the OEM for Windows NT and add records within that, logged in as user UIB. But when we try to open the recordset, no matter how we open it in VB, the recordsets lock type is returned as adLockReadOnly. Whenever we try to AddNew, it errors out in VB. Anyone have any suggestions?
If anyone needs any more additional information please ask. Thanks.
