473,322 Members | 1,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

MS Access odbc issues

I am having trouble with MS Access 2000 on Windows 2000 Pro.

The two problems are that it is taking very long to link to Informix
and Oracle through ODBC and queries from Informix and Oracle never
finish - the meter shows 99% complete - for hours and hours.

I have the latest ODBC drivers; defragged and chkdsk'ed the hard
drive; reinstalled Office.

Any other suggestions, hints, tips?

TIA

Pete
Nov 12 '05 #1
6 2199
On 28 Jan 2004 22:42:25 -0800, pe***@garlic.com (hedrew3) wrote:
I am having trouble with MS Access 2000 on Windows 2000 Pro.

The two problems are that it is taking very long to link to Informix
and Oracle through ODBC and queries from Informix and Oracle never
finish - the meter shows 99% complete - for hours and hours.

I have the latest ODBC drivers; defragged and chkdsk'ed the hard
drive; reinstalled Office.

Any other suggestions, hints, tips?

TIA

Pete


The first problem, I'm not sure, but it could be a DNS issue.

For the second problem, you never want to open an an unfiltered, unaggregated
view of a large table, but the one place you can't avoid it is when trying to
link to the table. What I've done in the past is to link to a view instead of
to the table, and put a where clause in the view that returns no records,
create the link to the view, then change the view definition to remove the
where clause. After that, Access is happy.
Nov 12 '05 #2
Thanks for your suggestions. I'll try the one with the blank view and
see what that does.

However, I have a problem even before that! Just getting a list of
available tables from the server so I can chooose which table to link
is taking an inordinate amount of time, let alone getting the data.

Pete
Nov 12 '05 #3
Yet another forgery. This message was sent through an anonymizer and did not
originate from Mike Storr.

On Sun, 01 Feb 2004 21:48:26 +0100, "Mike Storr" <no****@somewhere.con> wrote:
hedrew3 wrote:
Thanks for your suggestions. I'll try the one with the blank view and
see what that does.

However, I have a problem even before that! Just getting a list of
available tables from the server so I can chooose which table to link
is taking an inordinate amount of time, let alone getting the data.

Pete

Upgrade your ethernet. Instead of CAT 5, go with Monster Cable Gold speaker
wire, available at most stereo shops. It spead up my net 10 fold.



<INSERT HERE>{INANE TONY TOEWS FOLLOWUP}

Please ignore the above posting folks.

Tony


Nov 12 '05 #4
On Sun, 01 Feb 2004 21:00:51 GMT, Steve Jorgensen wrote:
Yet another forgery. This message was sent through an anonymizer and did not
originate from Mike Storr.

On Sun, 01 Feb 2004 21:48:26 +0100, "Mike Storr" <no****@somewhere.con> wrote:
hedrew3 wrote:
Thanks for your suggestions. I'll try the one with the blank view and
see what that does.

However, I have a problem even before that! Just getting a list of
available tables from the server so I can chooose which table to link
is taking an inordinate amount of time, let alone getting the data.

Pete

Upgrade your ethernet. Instead of CAT 5, go with Monster Cable Gold speaker
wire, available at most stereo shops. It spead up my net 10 fold.



<INSERT HERE>{INANE TONY TOEWS FOLLOWUP}

Please ignore the above posting folks.

Tony


How did I become a popular target? Did I blow up someone's death star or
something?

--
Mike Storr
veraccess.com
Nov 12 '05 #5
Mike Storr <st******@sympatico.ca> wrote:
How did I become a popular target? Did I blow up someone's death star or
something?


Random target. Several others were chosen as well.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #6

Try to use indexed fields from the target database. This will speed
your response up considerably. I am not familiar with Informix or
Oracle, but in other software Idx is added to a field name to
indicate it is indexed.

Filtering data in indexed fields is OK, but leave any other
calculations or processing until you have extracted the raw data
from the target database.

Regards

Peter

hedrew3 wrote:
I am having trouble with MS Access 2000 on Windows 2000 Pro.

The two problems are that it is taking very long to link to Informix
and Oracle through ODBC and queries from Informix and Oracle never
finish - the meter shows 99% complete - for hours and hours.

I have the latest ODBC drivers; defragged and chkdsk'ed the hard
drive; reinstalled Office.

Any other suggestions, hints, tips?

TIA

Pete


Nov 12 '05 #7

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

Similar topics

11
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...
1
by: David | last post by:
Having issues with a Pear DSN for odbc Microsoft access. The Manual is not too helpful and the best one I can find is odbc///map where map is the ODBC DSN name. Or does one need to...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
1
by: Paul | last post by:
Hello, I am converting an Access database on our network to a sql 2000 backend and keeping access as the front end. The access database has evolved and been a solution to collect data but now...
33
by: Steven Taylor | last post by:
Hope someone can help. This is half an Access question. The half I'm using is Access Xp as a backend data file. I'm using ODBC to connect to the data file. All commands are via SQL type...
0
by: ASP.Confused | last post by:
The old message looked a little stale, so I am re-posting it here. Anybody have any ideas of what I could do?!? The previous responses to this question are below. If you want to look at the...
5
by: somersbar | last post by:
hello all, im trying to connect to a microsoft access database from an ASP.NET web form. i keep getting the following error though: ERROR Could not use '(unknown)'; file already in use....
2
by: egoldthwait | last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with...
2
by: Joseph S. | last post by:
Hi all, I'm using the following setup: VB.Net (.NET framework 1.1) Access2000 SharpDevelop 1.1 for development (it is very similar to Visual Studio ..NET) using ODBCConnection, ODBCCommand,...
6
by: onnodb | last post by:
Hi all, While working on an Access UI to a MySQL database (which should be a reasonable, low-cost, flexible interface to the DB, better than web-based, much less costly than a full-fledged .NET...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.