topic RE: Use MS Access Application GUI - Slow to execute in Product Forum

Use MS Access Application GUI - Slow to execute

GCollin — Tue, 19 Nov 2019 13:48:00 GMT

Hi,

I'm currently working on Microsoft Access Application Form automation.

Everything works fine, I'm able to attach the application, spy element by using AA Mode but as soon as I need to highlight the element, it can take 2 minutes to find the element in the application, and the slowness is the same when I use the navigate stage(e.g. Global Mous Click Centre).

I know the reason, there's a lot of element in this MS access application (over 800) , so I've tried many combinations of attributes in the application modeller to optimize the search. Match index is always 1 for every element and ordinal as well. (Picture 1).

My solution will be to point directly to an element by getting his ancestor from InspectTool (Picture 2), but so far I'm not sure it's possible to do that.

Does anyone has already facing to that kind of problem?

Picture 1

Picture 2

------------------------------
G Collin
------------------------------

RE: Use MS Access Application GUI - Slow to execute

GopalBhaire — Wed, 20 Nov 2019 07:58:00 GMT

MS Access GUI can be quite slow to spy and having 800 elements on screen can surely be slow, have you tried UI Mode?

If you;re getting data you can try connecting to it using OLEDB, You can also run queries but that can be risky.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Use MS Access Application GUI - Slow to execute

david.l.morris — Wed, 20 Nov 2019 12:40:00 GMT

You mentioned Match Index is 1 for every element, but the image doesn't show the Match Index attribute selected.

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

RE: Use MS Access Application GUI - Slow to execute

GCollin — Wed, 20 Nov 2019 20:42:00 GMT

Hi Dave , Gopal,

I've tried a lot of combinations but not with Match Index selected 😞 , so I've selected it, and that fix the slowness issue. So now everything works fine

Thank you very much for the hint !:)

------------------------------
G Collin
------------------------------

RE: Use MS Access Application GUI - Slow to execute

GopalBhaire — Thu, 21 Nov 2019 04:05:00 GMT

Nice spot @Dave Morris

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Use MS Access Application GUI - Slow to execute

david.l.morris — Thu, 21 Nov 2019 12:31:00 GMT

Match Index is my best friend. 😃

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------