Access almost freeses aftera pass-through query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a few pass-through queries which execute SQL Server stored proc. After
I run these queries, Access slows down and become unresponsive - the only way
to get it to respond again is to reboot the machine!! Looking at my system
resources when this happens, everything seem to be OK - what is possibly
happening here?

Thanks,

Ivan
 
How are you executing the PTQ? In code, or dbWindow? If in code, you may
need to set used objects to nothing.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 
Thanks Steve,

The PTQ are executed in code, and the objects are set to nothing. Is there
maybe some obscure property that must be set somewhere?

Thanks,

Ivan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass Through Query - not returning rows 1
Pass Through Query .sql query 3
Question on Pass-through Query 4
Query on SQL Server is fast, while Access is crawling 2
Access pass-through query to Oracle 10g stored procedure - results 1
slow append query from a pass through query 4
Pass-Through performance issue 4
Pass-Through Query Error 1

Back
Top