By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,725 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

MS Access odbc issues

P: n/a
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
Share this Question
Share on Google+
6 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a

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 discussion thread is closed

Replies have been disabled for this discussion.