slow application

[Jean-Paul]

Hi,
I wrote this application that runs perfectly (or better: almost
perfectly...)
The problem is, on one computer it runs at a reasonable speed.. the same
application on another (HP) computer runs EXTREEMLY slow, although the
latter is the most recent and most fast computer.
All other applications runs fast enough, only this application doesn't.
What can cause this?
Thanks
JP

 

[bhicks11 via AccessMonster.com]

There are sooo many variables from machine to machine that it would be hard
to tell. Memory, disk access speed, what applications are loaded in startup,
network, etc. Try doing a selective start up and see if you can narrow
something down.

Bonnie

http://www.dataplus-svc.com

 

[Tony Toews [MVP]]

The problem is, on one computer it runs at a reasonable speed.. the same
application on another (HP) computer runs EXTREEMLY slow, although the
latter is the most recent and most fast computer.

Is this MDB/MDE shared among several users? Does the performance hit
happen only on the second user in?

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/

 

[Jean-Paul]

Is this MDB/MDE shared among several users? Does the performance hit
happen only on the second user in?

Tony

No Tony... single user..
All other apps run perfectly on this computer except for my access
application.
There is no difference between running as mdb or mde
Even entering a value in an entryfield, or scrolling takes much longer...
Thanks
JP

 

[John Spencer]

Any chance that the Anti-Virus software is interfering with the process?

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Tony Toews [MVP]]

No Tony... single user..
All other apps run perfectly on this computer except for my access
application.
There is no difference between running as mdb or mde
Even entering a value in an entryfield, or scrolling takes much longer...

We've had isolated reports of this problem. Try importing all the
objects into a new MDB/ACCDB and see if that helps.

Also what are the references?

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub

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/

 

[Jean-Paul]

importing in a new MDB made no difference.
I added your code into mine and got a "type mismatch" (I have to
translate the errormessage from my Dutch Access version) errormessage...

Thanks for your kind help
JP

 

[Tony Toews [MVP]]

I added your code into mine and got a "type mismatch" (I have to
translate the errormessage from my Dutch Access version) errormessage...

Interesting. Try the following code then.

Sub DebugPrintReferences()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " " & _
IIf(ref.IsBroken, "Broken", _
ref.Major & "." & ref.Minor & " " & _
ref.FullPath)
Next ref

End Sub

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/

 

[Jean-Paul]

looks it was some spyware/virus that slowed things down...
did some scanning an cleaning... problem solved
Thanks
JP

 

[Tony Toews [MVP]]

looks it was some spyware/virus that slowed things down...
did some scanning an cleaning... problem solved

Fabulous. Thanks for posting back.

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/