473,688 Members | 3,202 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Converting from Access 2000 to Access 2003, execute for a sql insert, update not working

Hi all,

I'm sure someone knows about this problem. I have an Access database
designed in Access 2000, connected to an ORACLE 8i back end. On the
ORACLE side I have stored procedures, triggers and views that kick off
at different times. My Access 2000 database works well.

Problem:
I converted the database to Access 2003 am using ORACLE again as my
back end (they have updated the drivers in Oracle to 9i). I an trying
to execute a querydef, when I follow both programs in 2000 the .Execute
executes, when I run it in 2003 it hits the .execute and seems to goto
the On Error GoTo proc_err procedure which brings up a message that
there is someone putting the same information into the table. Can
anyone tell me why the .execute works in 2000 but not 2003 and is this
a problem with XP compared to 2000.
Set qdf = CurrentDb.Creat eQueryDef("", strSQL)
With qdf
.Connect = strConnect
.ReturnsRecords = False

'Perform the insertion, allowing 3 retries on error in case of
contention
intRetry = 0
On Error GoTo proc_retry
.Execute
On Error GoTo proc_err

Feb 13 '06 #1
2 2435
Gox
Ch************* **@pw.utc.com wrote:
Hi all,

I'm sure someone knows about this problem. I have an Access database
designed in Access 2000, connected to an ORACLE 8i back end. On the
ORACLE side I have stored procedures, triggers and views that kick off
at different times. My Access 2000 database works well.

Problem:
I converted the database to Access 2003 am using ORACLE again as my
back end (they have updated the drivers in Oracle to 9i). I an trying
to execute a querydef, when I follow both programs in 2000 the .Execute
executes, when I run it in 2003 it hits the .execute and seems to goto
the On Error GoTo proc_err procedure which brings up a message that
there is someone putting the same information into the table. Can
anyone tell me why the .execute works in 2000 but not 2003 and is this
a problem with XP compared to 2000.
Set qdf = CurrentDb.Creat eQueryDef("", strSQL)
With qdf
.Connect = strConnect
.ReturnsRecords = False

'Perform the insertion, allowing 3 retries on error in case of
contention
intRetry = 0
On Error GoTo proc_retry
.Execute
On Error GoTo proc_err


Hi Christine,

I have a same problem like you, but in my case this not work:

db.QueryDefs.De lete NameOfQuery

On some client machine (Win XP + SP2, Office 2003) works well, but on
others machine (same config -> Win XP + SP2, Office 2003) not work.
I think problem is Access config or Jet

People help us!!

Feb 14 '06 #2
Hi,

I do know that we have the updated SP for Jet the latest one. Some of
my digging I found there is another SP for Office 2003, I know my
company needs to install Office 2003 SP2. Is there a work around for
converting an Access 2000 program to an Access 2003 program? Do I need
to import the forms, modules, reports & classes, like we had to from 97
to 2000? Do I need to rewrite this program in 2003 or can I convert &
then redo the forms & reports?

Thanks,
Chris

Feb 15 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
2313
by: jason | last post by:
Is there a way - possibly a disconnected rs? - to update the contents of an existing pulldown on a page without having to re-submit the page for the user to see the pulldown populated with an additional value? I realise there are javascript possibilities (and I am still searching for a usable one) but I thought perhaps it may be possible to allow a user to add a new entry to a drop down box that had been dynamically populated from an...
11
3753
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue, I am posting this on all of the three newsgroups. That's the setup: Windows 2003 Server with IIS and ASP.NET actiavted Access 2002 mdb file (and yes, proper rights are set on TMP paths and path,
23
2682
by: JustMe | last post by:
I don't know if this has anything to do with AccessXP running on Terminal Services with Access97/2000 also installed, but here is one example of a query that does not work any longer: SELECT DLookUp("MajorCategory","AutoTypes","='1'") AS MajorCategory, PreOwned.PaintColor FROM PreOwned; When I try to run the above query I get the following error:
3
12594
by: ILCSP | last post by:
Hello, I'm fairly new to the concept of running action pass through queries (insert, update, etc.) from Access 2000. I have a SQL Server 2000 database and I'm using a Access 2K database as my front end. I'm using a blank pass through query which gets the Transact-SQL part inserted from a button in my form. After inserting the Transact-SQL code into the pass through query, I 'open the recordset' to make the query run. However,...
32
12505
by: robert d via AccessMonster.com | last post by:
I'm looking at converting DAO to ADO in my app. All of my DAO connections are of the following structure: Dim wsName As DAO.Workspace Dim dbName As DAO.Database Dim rsName As DAO.Recordset Set wsName = DBEngine.Workspaces(0) Set dbName = wsName.OpenDatabase(CurrentProject.FullName) Set rsName = dbName.OpenRecordset("SQL Statement")
0
1994
by: CWogksch | last post by:
Hello, Everyone... My name is Chris Wogksch. I have a point of sale application developed in VB6 using MS Access 2003 as the database. I've been running versions of this app for over eight years, using vb5/Access 97 and later vb6/Access 2000 and 2003, without issue. Recently, I've started selling my latest version to liquor stores in my local area. The typical installation setup is a peer-to-peer network with three workstations; a...
6
5595
by: venmore | last post by:
Hi Can someone please point in the right direction. I have an XML file that gets updated every 4 hours on a web server. I can check the XML modification time in ASP and compare to the databse. If it is newer, I need some ASP code to then import the XML into Access. Been trawling the net for an answer for a while - no joy thanks
6
2672
by: jsacrey | last post by:
Hello everybody, I've got a bit of a situation that I could use some guidance with if possible. I work for an auditing firm where my users audit electronic shipping data for customers to see if they've been overcharged for shipments by truck and rail carriers. 99.9% of the time, one of our auditors needs to see all data sent by a customer in datasheet view so that they can sort records in many different ways looking for duplication...
2
3500
by: raghunadhs | last post by:
Hi All, i have some simple scripts( which may have some insert statements, update statements etc). these scripts were written in Sql server 2000. now i want to use the same scripts in Access. (since the data is same in both Access, Sql server databases). can i write the scripts in Access-2003? if so please help me. Actually i tried with simple examples. it is working fine for insert, update statements. but it is not working for "If" state...
0
8590
marktang
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...
0
9072
Oralloy
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...
0
8947
jinu1996
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...
0
8786
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6453
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4321
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...
1
2964
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2215
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1950
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.