slow application

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

Jean-Paul wrote:
>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

--
Message posted via http://www.accessmonster.com

Tony Toews [MVP] wrote:
> Jean-Paul <jp.dewinter.RemoveThis@telenet.be> wrote:
>
>> 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
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

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

Jean-Paul wrote:
> Tony Toews [MVP] wrote:
>> Jean-Paul <jp.dewinter.TakeThisOut@telenet.be> wrote:
>>
>>> 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
> 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

Jean-Paul <jp.dewinter DeleteThis @telenet.be> wrote:

> 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/

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] wrote:
> Jean-Paul <jp.dewinter.RemoveThis@telenet.be> wrote:
>
>> 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

Jean-Paul <jp.dewinter.TakeThisOut@telenet.be> wrote:

>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/