By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,411 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

'operation was canceled' error. Please help.

P: n/a
Hello all,
I am so frustrated. I am doing something so simple and yet I confront
such a problem.
I am writing a program in VB, opening a db connection to an access db
using ADODC control. I disply a record's fields and I can navigate
through the recordset. BUT when trying to change a field content or
when adding a new record I receive the error: 'operation was canceled'
and from then I can no longer navigate the control.
I installed VB's sp5 and the table stands alone in the db (does not
relay on any other table in the db). I am helpless.
PLEASE HELP.
Tami.
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Tamar wrote:
Hello all,
I am so frustrated. I am doing something so simple and yet I confront
such a problem.
I am writing a program in VB, opening a db connection to an access db
using ADODC control. I disply a record's fields and I can navigate
through the recordset. BUT when trying to change a field content or
when adding a new record I receive the error: 'operation was canceled'
and from then I can no longer navigate the control.
I installed VB's sp5 and the table stands alone in the db (does not
relay on any other table in the db). I am helpless.
PLEASE HELP.
Tami.


In Access, we have events that are called where you can cancel an
action. On of them is the beforeupdate event. Ex:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If x <> y then Cancel = True
end sub

Do you have any code that does something like that?

Tables and database can be opened as read-only, is yours opened
read/write? We can also set forms so allowadditions/allowedits is
false. Anything like that? Check you connection string.

Do your tables have a primary key? I read somewhere that ODBC tables
are read-only if no primary key exists.

Nov 12 '05 #2

P: n/a
I have not used ADODC, but my experience is that when ADO raises the error you
are describing, it is preceeded by several other more informative error
messages if you check the Errors collection of the ADO Connection object you
are using.

On 19 Apr 2004 03:36:38 -0700, ta************@cisghana.com (Tamar) wrote:
Hello all,
I am so frustrated. I am doing something so simple and yet I confront
such a problem.
I am writing a program in VB, opening a db connection to an access db
using ADODC control. I disply a record's fields and I can navigate
through the recordset. BUT when trying to change a field content or
when adding a new record I receive the error: 'operation was canceled'
and from then I can no longer navigate the control.
I installed VB's sp5 and the table stands alone in the db (does not
relay on any other table in the db). I am helpless.
PLEASE HELP.
Tami.


Nov 12 '05 #3

P: n/a
Tamar wrote:
Hello all,
I am so frustrated. I am doing something so simple and yet I confront
such a problem.
I am writing a program in VB, opening a db connection to an access db
using ADODC control. I disply a record's fields and I can navigate
through the recordset. BUT when trying to change a field content or
when adding a new record I receive the error: 'operation was canceled'
and from then I can no longer navigate the control.
I installed VB's sp5 and the table stands alone in the db (does not
relay on any other table in the db). I am helpless.
PLEASE HELP.
Tami.


In Access, we have events that are called where you can cancel an
action. On of them is the beforeupdate event. Ex:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If x <> y then Cancel = True
end sub

Do you have any code that does something like that?

Tables and database can be opened as read-only, is yours opened
read/write? We can also set forms so allowadditions/allowedits is
false. Anything like that? Check you connection string.

Do your tables have a primary key? I read somewhere that ODBC tables
are read-only if no primary key exists.

Nov 12 '05 #4

P: n/a
I have not used ADODC, but my experience is that when ADO raises the error you
are describing, it is preceeded by several other more informative error
messages if you check the Errors collection of the ADO Connection object you
are using.

On 19 Apr 2004 03:36:38 -0700, ta************@cisghana.com (Tamar) wrote:
Hello all,
I am so frustrated. I am doing something so simple and yet I confront
such a problem.
I am writing a program in VB, opening a db connection to an access db
using ADODC control. I disply a record's fields and I can navigate
through the recordset. BUT when trying to change a field content or
when adding a new record I receive the error: 'operation was canceled'
and from then I can no longer navigate the control.
I installed VB's sp5 and the table stands alone in the db (does not
relay on any other table in the db). I am helpless.
PLEASE HELP.
Tami.


Nov 12 '05 #5

P: n/a

Hello Steve,
Thanks very much for the reply. eventually, I opened a new vb project,
useing the same forms, opened a new db useing the same tables and all is
fine. I used the software developeres solution for all problems
(restart).
Tami.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.