hangs on exit

[dcccgoose via AccessMonster.com]

I have no formal training. I'll do my best to explain what I have so far. I
have a DB to keep tract of addresses, donors and donations for a charity. I
have a main table and a form associated with it. I have several check boxes
on that form that respond to queries, "mailing list, donor, etc." There are
3 tables in all, the main one, donors and donations (the last 2 have a one to
many relationship and form with subform). There are 6 queries. The six
queries are: 05 donations (from donors and donations), christmas card list
(off main table), donor append (off main table), mailing list (off main table)
, donations from past year (from donors and donations tables), need to send
thank you (from donors and donations table). I use the queries to merge with
Word to create letters, envelopes, etc. I have 2 reports, 05 gift receipt
and past year gift receipt. (I'll be able to use the past year gift receipt
and the query that creates it, donations from past year, from now on by just
changing the date in the query.) Anyway, the problem I have is that it takes
a long time for the DB to open and if I work in more than one form, query,
etc it will hang on exit. The only way I know it does this is the office
assistant remains on the desk top or the computer seems really slow. I then
find Access is using 99 percent of the mem in ctrl, alt, delete and have to
shut it down from there. What am I doing wrong?

 

[Guest]

Probably not your fault at all. FYI: Sometimes says that it's using 100% cpu
but it readily gives it up when needed.

Go to Tools, Options, General Tab and turn off Name Autocorrect on all of
your databases. IMHO it's a piece of do-do and the cause of many problems.
Hopefully turning it off will fix yours.

While there also turn off Compact on Close if enabled. You'll be glad that
you did. It can cause very slow shutdowns and other problems. Manually
compact the database once a week or so. I do mine monthly.

Also try turning off your virus checker. Just make sure that you aren't
connected to a network or internet while doing this. If Access runs better
see if there is a way to exclude .mdb or .md* files from scanning. Most virus
checker programs allow you to do so unless your network people have locked
down your computer.

One last thing. Next time you ask a question (1) tell which version of
Access as it can make a difference and (2) get to the point faster as your
actual question was only in the last 4 sentences. If you provide too little
information, we can't help. If you put too much, people will often just pass
over your question.

I had no formal training either. When I started out on Access, I was an
aircraft mechanic! Now I train others.

 

[dcccgoose via AccessMonster.com]

Thank you so much for your reply. Sorry about all the info. I was half
expecting to have someone say that I'm doing it all wrong. I'll try the
things you suggested. Thanks again.

Probably not your fault at all. FYI: Sometimes says that it's using 100% cpu
but it readily gives it up when needed.

Go to Tools, Options, General Tab and turn off Name Autocorrect on all of
your databases. IMHO it's a piece of do-do and the cause of many problems.
Hopefully turning it off will fix yours.

While there also turn off Compact on Close if enabled. You'll be glad that
you did. It can cause very slow shutdowns and other problems. Manually
compact the database once a week or so. I do mine monthly.

Also try turning off your virus checker. Just make sure that you aren't
connected to a network or internet while doing this. If Access runs better
see if there is a way to exclude .mdb or .md* files from scanning. Most virus
checker programs allow you to do so unless your network people have locked
down your computer.

One last thing. Next time you ask a question (1) tell which version of
Access as it can make a difference and (2) get to the point faster as your
actual question was only in the last 4 sentences. If you provide too little
information, we can't help. If you put too much, people will often just pass
over your question.

I had no formal training either. When I started out on Access, I was an
aircraft mechanic! Now I train others.

I have no formal training. I'll do my best to explain what I have so far. I
have a DB to keep tract of addresses, donors and donations for a charity. I

[quoted text clipped - 15 lines]

find Access is using 99 percent of the mem in ctrl, alt, delete and have to
shut it down from there. What am I doing wrong?

 

[dcccgoose via AccessMonster.com]

P.S. I'm using Access 2003

Thank you so much for your reply. Sorry about all the info. I was half
expecting to have someone say that I'm doing it all wrong. I'll try the
things you suggested. Thanks again.

Probably not your fault at all. FYI: Sometimes says that it's using 100% cpu
but it readily gives it up when needed.

[quoted text clipped - 26 lines]

 

[Guest]

Let us know what you find out. Your Access problem is slightly different than
normal.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

P.S. I'm using Access 2003

Thank you so much for your reply. Sorry about all the info. I was half
expecting to have someone say that I'm doing it all wrong. I'll try the
things you suggested. Thanks again.

Probably not your fault at all. FYI: Sometimes says that it's using 100% cpu
but it readily gives it up when needed.

[quoted text clipped - 26 lines]

find Access is using 99 percent of the mem in ctrl, alt, delete and have to
shut it down from there. What am I doing wrong?