Access makes unrealistic number of connections to Oracle

[Mattias Jonsson]

This is a repost from microsoft.public.access.odbcclientsvr where posting
seems very slow. Hope for better luck here in
microsoft.public.access.formscoding

All,
I have a front-end application that is racking up the # of connections to an
Oracle server more quickly than I can count. Yesterday it was 1200 and this
morning it's up to 200 already. It is using linked tables. There are some
basic bound forms that have dropdowns to pick records. Using MS ODBC for
Oracle driver, Oracle 92 client and Oracle server version 8.1.7.0. The
front-end is hosted on a Citrix server (but that should not affect the
situation).

Any idea why this would happen is appreciated.

Thanks,
Mattias Jonsson

Addl. information since the original post: This seems to have something to
do with subforms and combo boxes. When opening a single form with five
subforms, I can get as many as 24 connections to Oracle instantly opened and
closed.

 

[Mattias Jonsson]

FIXED! Call off the dogs. It was the "Microsoft ODBC for Oracle" driver that
caused it. Switched over to use the native Oracle and it's back to using one
connection per app.