Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

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.
0
htay
Asked:
htay
  • 3
  • 3
1 Solution
 
DQCommented:
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
0
 
htayAuthor Commented:
Thanks
0
 
htayAuthor Commented:
Thanks
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DalinCommented:
DQ, You should lock the question, since htay seemed to be happy with your answer.

0
 
DQCommented:
You are welcome.
Good luck
0
 
htayAuthor Commented:
By the way, do you know any good book talks between VB and Oracle?

Thanks!


0
 
DQCommented:
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.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now