Access 2002 is freezing up, 97 runs perfect

E

Erik van Opmeer

Hi all,

I am at my wits end...
I have an application that had been running fine (even in
XP) however the last week or so it is Freezing.

In the taskbar it shows as "Responding" but no way....

This is the setup:
The application does a bunch of ODBCs to an Oracle
database, 250 or so records in Access averaging about 3
ODBCs each.
I am connecting using:
Set con = wrkODBC.OpenConnection("ODBCConnection", , , _
"ODBC;DSN=" & DSN & _
";UID=" & User & _
";PWD=" & PW & _
";SERVER=" & Server & _
";")

Then i am creating my query:
Set qry = con.CreateQueryDef("", mySQL)
Where mySQL contains a perfectly nice (but long) SQL
statement (select)

Next, open the (DAO) recordset:
Set rst = qry.OpenRecordset
Then working a bit with this and 2 other recordsets.

After all that is done, i do:
rst.Close
set rst = nothing

And start the loop all over.... (without connecting again
offcourse)

Any wise people out there that can help me along?
Oh, one more thing... This app had been running smoothly
in XP as well for atleast 3 months before this problem
occured.

Greets & many thanks

Erik
 
Top