Solved

Microsoft Access 2007 Very slow on query running to Oracle Database

Posted on 2011-09-26
8
271 Views
Last Modified: 2012-05-12
Microsoft Access 2007 Very slow on query running to Oracle Database.
Query to Oracle 10g database running slow or fail. This query runs fine on another laptop.
No idea what is causing the issue.
0
Comment
Question by:carlisle_cibf
  • 4
  • 4
8 Comments
 

Author Comment

by:carlisle_cibf
ID: 36601366
Microsoft Access 2007 Very slow on query running to Oracle Database.
Need help on why this query runs slow on newer computers, but fine on old XP computer that is 10 years.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36643528
What hardware/software configuration are the new computers?

New computers will typically require new drivers to connect to the source.

How are you connecting to the Oracle source?
0
 

Author Comment

by:carlisle_cibf
ID: 36659362
Oracle 10g ODBC drivers.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36707812
I also asked about the software on the new computers...
0
 

Author Comment

by:carlisle_cibf
ID: 36708892
Windows 7.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36710069
what edition/Version of Win 7?
Home
Pro
Ultimate
32 bit
64 bit
?

Oracle will have specific drivers possibly for each.
(in the same way you install a Printer Driver specific to the OS)
0
 

Author Comment

by:carlisle_cibf
ID: 36710542
Windows 7 Pro/32 bit.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 36710893
So make sure you have the Oracle drivers installed for this version of windows...
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question