Link to home
Start Free TrialLog in
Avatar of htay
htay

asked on

Run-tume error '3027'

Hi,

I have a run-time error '3027' while I intended tp update, edit a data from Oracle.  The message says "Can't update.  Database or objects is read only."  By the way, I am using VB as a front-end, and Oracle as a back-end.

Can someone help?  Thanks in advance.
Avatar of DQ
DQ
this error sometimes caused by:
1) Open recordset as Snapshot (this is read only, can't be     update).
   
    Try open recordset as Dynaset or Table.

2) Set DbReadonly  or DbDenyWrite option to true when you         open Database.

    Try set the option to DBAppendOnly(For add only) or
    egnore this option
Avatar of htay
htay

ASKER

Thanks
Avatar of htay
htay

ASKER

Thanks
Avatar of Dalin
Dalin
DQ, You should lock the question, since htay seemed to be happy with your answer.

ASKER CERTIFIED SOLUTION
Avatar of DQ
DQ
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of htay
htay

ASKER

By the way, do you know any good book talks between VB and Oracle?

Thanks!


Avatar of DQ
DQ
I am not sure if there is a book epscifically for the two.
How ever, any Vb database book will talk about ODBC, RDO in general.