DAO garbage cleanup taking a LONG time... 
Author Message
 DAO garbage cleanup taking a LONG time...

Hello All-

  I have some code that creates a new blank database and then copies
the schema from another database into it using DAO. It's working fine
(and fast) until the very end when we attempt to free up the two
dao.database variables we're using. Between the two of them they take
7-8 minutes to close! This happens whether I use ".close" or "set db =
nothing" or just let Access clean up automatically.

  What's going on? Any ideas?

  This is Access XP SP-1... DAO 3.6 & Jet 4.0 (Service Pack 6).


Wed, 02 Feb 2005 05:46:50 GMT  
 DAO garbage cleanup taking a LONG time...

Do you have "Name AutoCorrect" feature turned on? If so, please turn it off.

It's hard to determine the cause of the problem, but try to run ".close"
"set db=nothing" in earlier stage, and see if the problem perisists. This
will help determine which code section causes the problem.

Jun Chen

This posting is provided "AS IS" with no warranties, and confers no rights.

Fri, 04 Feb 2005 17:35:12 GMT  
 [ 2 post ] 

 Relevant Pages 

1. It takes a long time to open Form

2. Script Control "Taking a long time"

3. Saving takes 100 times longer than loading..?

4. CreateObject takes unreasonably long time

5. VB InputB takes a long time in COM+

6. Accessing Paradox Table Takes *Long* Time

7. Takes a long time to truncate a SQL Svr table from a VB application

8. Establishing Dataabse connection takes long time

9. saving takes 100 times longer than loading...???

10. Image Combo shows garbage characters if text is longer than 60

11. creating nodes in treeview taking a long long long long .....

12. Why query takes longer and longer as time goes on?


Powered by phpBB® Forum Software