472,782 Members | 3,310 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,782 software developers and data experts.

DBEngine - Access 2003 vs Access 2010

Hi folks,

My company recently upgraded our Office suite from 2003 to 2010. The problem in particular is with an Access database that was originally designed in Access 2003. The code in question used work in 2003 (see below code).

Expand|Select|Wrap|Line Numbers
  1. Private Sub engSave_Click()
  3.     Dim strSql3 As String
  5.     'Archive order number and cost data for engine.
  6.         strSql3 = "UPDATE tblQuotePkgEngine INNER JOIN qryQuotePkgEngine ON " & _
  7.             "(tblQuotePkgEngine.engPrcID = qryQuotePkgEngine.engPrcID) " & _
  8.             " AND (tblQuotePkgEngine.pkgID = qryQuotePkgEngine.pkgID) " & _
  9.             " SET tblQuotePkgEngine.soHist = [qryQuotePkgEngine]![OrderNo], " & _
  10.             " tblQuotePkgEngine.costHist = [qryQuotePkgEngine]![Cost (CDN)], " & _
  11.             " tblQuotePkgEngine.prcHist = [qryQuotePkgEngine]![Price] " & _
  12.             " WHERE (((tblQuotePkgEngine.pkgID)= " & Me.pkgID & "));"
  13.         DBEngine(0)(0).Execute strSql3, dbFailOnError
  15.         Forms![fmQuotePkgDetails].Refresh
  16.         Forms![fmQuotePkgDetails]![modDate] = date
  18.         MsgBox ("Engine modification now saved.")
  20. End Sub
Since the upgrade to 2010, this chunk of code no longer seems to work. No error messages are given. In fact by all appearances, it looks like it executes the code as the final message I see is the msgbox item but when you look on the table, values that are supposed to be copied to the archive fields are not being executed. My suspicion is that it has to do with the "DBEngine(0)(0).Execute strSql3, dbFailOnError" chunk of code, in particular the DBEngine(0)(0) piece.

I'm assuming Access 2010 does not recognize this anymore?

Can someone enlighten me please as this is something I've been trying to chase down for the last day or so.

Thanks in advance.

Nov 18 '10 #1
1 5160
32,534 Expert Mod 16PB
I can't help much here Alan I'm afraid, but were I in your position I would :
  1. Trace (See Debugging in VBA) through the code until you determined that the results were not as you expected. That will give you which line is not behaving as expected.
  2. Search the web for pages dealing with differences between versions of Access (You may want to start at Exploring Office 2010).
Nov 18 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Wayne Aprato | last post by:
The controltip text has disappeared in all of my databases in Access 2003 (Access 2000 format). The same controltips show fine when running under Access 2000 on my laptop. Maybe I've missed it,...
by: Neil Ginsberg | last post by:
I have a client who is using Access 2002/2000 (the database itself is written in 2000), and is considering migrating to Access 2003. Any recommendations on whether Access 2003 is worth the migrate,...
by: Mike Gramelspacher | last post by:
Hello, I have an Access 2000 database that I copied to a new computer with Access 2003. Access 2003 says the file is in Access 2000 file format. I made some changes to the Access 2000 file...
by: paul.hanti | last post by:
I've built a shared database that sits on shared network drive using Access 2003 (Access 2000 file format). I've also built a simple query form that uses unbound textbox controls to build the...
by: Wayne | last post by:
I'm experiencing the following intermittent problem with Access 2003 (Access 2000 file format) under Vista. Sometimes when I close a database by closing the database window I get the following...
by: Bruce | last post by:
I have a number of Access 2000 format databases on a Windows 2003 server. For some reason I can no longer compact these databases directly on the server using Access 2003. Access 2000 seems to...
by: mstres | last post by:
How to call Stored Function in Mysql from Access 2003 Access 2003 I am using as Front End and Access DB have a link table to MySql DB with ODBC connection Thank you Mike
by: b wesenberg | last post by:
Good Morning, I am hoping that someone can assist me with a code problem. Here is the history of the issue. We had a database that was created in Access 2003 the database had a module in it...
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

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.