strange sluggish behavior in A 2000 DB

  • Thread starter Thread starter Alan B.
  • Start date Start date
A

Alan B.

I have an Access database. A 2000 front end of 9.4 MB, and an A 97 back end
of 37 MB. Everything was running fine up to a few days ago. Now it is acting
strange when client is run both under Win 200 Pro and Win XP Pro on two
different computers.

For example, when I open the database front end and then click a button on
my main menu to open one of the forms, the mouse cursor stays an "I" beam
until I click it on a blank space on the form. Then it turns back into the
usual arrow cursor. This seems to happen on all of the forms, not just one
specific one.

One of the functions in my database is for batch emailing. Now when I try to
email, it will send the first email, but not send any more until I minimize
the A 2000 front end, and then it sends out the rest of the emails.

I've decompiled, recompiled and compacted the Front End. And I've repaired
and compacted the back end. I've been at this stuff with Access since Access
2 back in 1992, but I've never run into this kind of behavior before. I
cannot find anything wrong in either the front or back end. However, it's
misbehaving and it's a real pain.

Does anybody have any ideas or had the same experience?

Regards,
Alan
 
Alan B. said:
I have an Access database. A 2000 front end of 9.4 MB, and an A 97 back end
of 37 MB. Everything was running fine up to a few days ago. Now it is acting
strange when client is run both under Win 200 Pro and Win XP Pro on two
different computers.

For example, when I open the database front end and then click a button on
my main menu to open one of the forms, the mouse cursor stays an "I" beam
until I click it on a blank space on the form. Then it turns back into the
usual arrow cursor. This seems to happen on all of the forms, not just one
specific one.

One of the functions in my database is for batch emailing. Now when I try to
email, it will send the first email, but not send any more until I minimize
the A 2000 front end, and then it sends out the rest of the emails.
Click to expand...

Are you up to date on all the Office/Access patches on those
computers?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Hi Tony,

Yes, all updates were applied a long time ago, and both of these computers
have never had any problems like this.

Here is another symptom: I have an automation function that allows me to
send a single email from an Access form. It then opens the email in Outlook
2000. Sometimes when I click the Send button, the screen freezes, while the
email seems to have actually been sent. When I click the mouse anywhere on
the screen, it unfreezes and changes to the appropriate view of Outlook.

Any ideas?

Regards,
Alan
 
Tony,

I don't know what's going on with this post. All of a sudden it was deleted.
I will repeat the original post, with my answer to you plus some additional
information. Thanks in advance for your help.

Hello,
I don't know what happened to my original post. Someone deleted it.

I have an Access database. A 2000 front end of 9.4 MB, and an A 97 back end
of 37 MB. Everything was running fine up to a few days ago. Now it is acting
strange when client is run both under Win 200 Pro and Win XP Pro on two
different computers.

For example, when I open the database front end and then click a button on
my main menu to open one of the forms, the mouse cursor stays an "I" beam
until I click it on a blank space on the form. Then it turns back into the
usual arrow cursor. This seems to happen on all of the forms, not just one
specific one.

One of the functions in my database is for batch emailing. Now when I try to
email, it will send the first email, but not send any more until I minimize
the A 2000 front end, and then it sends out the rest of the emails.

I've decompiled, recompiled and compacted the Front End. And I've repaired
and compacted the back end. I've been at this stuff with Access since Access
2 back in 1992, but I've never run into this kind of behavior before. I
cannot find anything wrong in either the front or back end. However, it's
misbehaving and it's a real pain.

Does anybody have any ideas or had the same experience?

All Office and Access updates were applied a long time ago, and both of
these computers have never had any problems like this.

Here is another symptom: I have an automation function that allows me to
send a single email from an Access form. It then opens the email in Outlook
2000. Sometimes when I click the Send button, the screen freezes, while the
email seems to have actually been sent. When I click the mouse anywhere on
the screen, it unfreezes and changes to the appropriate view of Outlook.

Any ideas?

Regards,

Alan
 
Hello Tony,

I don't know what happened to my original post. Someone deleted it.

I have an Access database. A 2000 front end of 9.4 MB, and an A 97 back end
of 37 MB. Everything was running fine up to a few days ago. Now it is acting
strange when client is run both under Win 200 Pro and Win XP Pro on two
different computers.

For example, when I open the database front end and then click a button on
my main menu to open one of the forms, the mouse cursor stays an "I" beam
until I click it on a blank space on the form. Then it turns back into the
usual arrow cursor. This seems to happen on all of the forms, not just one
specific one.

One of the functions in my database is for batch emailing. Now when I try to
email, it will send the first email, but not send any more until I minimize
the A 2000 front end, and then it sends out the rest of the emails.

I've decompiled, recompiled and compacted the Front End. And I've repaired
and compacted the back end. I've been at this stuff with Access since Access
2 back in 1992, but I've never run into this kind of behavior before. I
cannot find anything wrong in either the front or back end. However, it's
misbehaving and it's a real pain.

Does anybody have any ideas or had the same experience?

All Office and Access updates were applied a long time ago, and both of
these computers have never had any problems like this.

Here is another symptom: I have an automation function that allows me to
send a single email from an Access form. It then opens the email in Outlook
2000. Sometimes when I click the Send button, the screen freezes, while the
email seems to have actually been sent. When I click the mouse anywhere on
the screen, it unfreezes and changes to the appropriate view of Outlook.

Any ideas?

Regards,

Alan
 
Sorry for the multiple posts. Something weird going on on my Win 2000 Pro
computer. It looks like my posts were deleted. However, everything appears
okay from my XP Pro computer.
 
Back
Top