Database Hangups

J

JonWayn

I have an Access 2003 database that gets most of its functionality from a
reference to another Access 2003 mdb library. There are lots of tables and
queries some links and others local. Whenever I run my daily routines of this
database, they run fine. However, when I go to close the database, it hangs
up. At times I open Task Manager just before closing it, scroll down to the
process of the database which shows 0% CPU usage until the second I hit the
close button to shut the database down. At that point, the CPU usage of this
process jumps to 24+ and the database hangs. At this point I have to use Task
Manager to close it. Does anybody here have any ideas as why this might be
happening? Thanks
 
A

AccessVandal via AccessMonster.com

If you have open an object, make sure you close it "Set Object = Nothing". If
you open a recordset, close it "rsRecordset.Close"

Take a look at Allen Browne's site on tips of how to prevent some of the
problems you're having.

http://allenbrowne.com/tips.html
 

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

Top