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. 5 6344
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_BeforeUpda te(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.
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.
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_BeforeUpda te(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.
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.
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! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mark |
last post by:
Hi - Can anyone please help with the error message below - server is XP
Pro, and the ASP code it is failing at is (set
MM_rsUser.ActiveConnection... as below):
<%
MM_valUsername=CStr(Request.Form("username"))
If MM_valUsername <> "" Then
MM_redirectLoginSuccess="fixit_ebase.asp"
MM_redirectLoginFailed="fixit_login.asp?failed=yes"
MM_flag="ADODB.Recordset"
|
by: intrader |
last post by:
I am getting "500 Internal Server Error" while creating a new Web
Project. The site is up for other existing projects, it is only when
creating a new project. No folders are created yet, nothing has been
written to.
Please help!
|
by: tasheeta |
last post by:
In my simple program I am getting this error..please help
I am trying to find integers where 65537i + 3551j = 1
error: cannot convert `__complex__ int' to `long int' in
assignment
#include <iostream>
#include <complex>
|
by: Andrew Ayers |
last post by:
All,
I am having a problem with an INSERT onto a table I have created. First
off, here is the table:
---
CREATE TABLE reg ("customer number" SERIAL PRIMARY KEY, "company name"
VARCHAR(50) NULL, address VARCHAR(100) NULL, city VARCHAR(50) NULL,
state VARCHAR(2) NULL, zip VARCHAR(50) NULL, phone VARCHAR(50) NULL,
|
by: Tamar |
last post by:
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...
| |
by: Vishal Saxena |
last post by:
Hi,
I am new to this news group, hope to get prompt solution from you, gurus of
VC.
Well i had a project developed in VC++ 6.0, it uses Adobe Plugin Development
SDK, I am trying to upgrade my project to VC++.NET,
below is the code snipplet from the project
|
by: momo |
last post by:
Hello Guys,
I am getting this error "
Control 'oGrid__ctl14__ctl1' of type 'DataGridLinkButton' must be placed
inside a form tag with runat=server."
Here is my code and I don't know where it is doing it. Can some please help
me
|
by: JumpingOffPlace |
last post by:
Hi,
I'm hoping that the wealth of knowledge here can stop me from spinning
my wheels on this syntax error for hours. :)
Below is the code, and the error I am recieving....
Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ taglib uri="/WEB-INF/tag-lib/struts-html-el.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/tag-lib/struts-bean.tld" prefix="bean" %>
|
by: smtwtfs007 |
last post by:
Any body has any idea about his error please?
I got this error at the time of creating crystal report. I tried
everything to resolve this error. But I could not. Please help.
Exception has been thrown by the target of an invocation. at
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object parameters,
CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |