How to speed-up Access DataBase on a Split table (1 Viewer)

M

Moore71

DEVELOPER

Local time

Today, 12:19

Joined

Jul 14, 2012

Messages

158

• Jan 5, 2020

• #1

Hi,
I have a solution being used by 2 users on a Lan/Wlan. Initially there wasn't any complain until recently they are complaining of too slow activities
I went there to check and you need to wait minutes for one process to perform
I change selecting Items from a ComboBox traditionally to using code to fetch data and I index almost every tables, but no valid result from that. I ask them to archive the data to start fresh entry but they reject that (It's a sales outlet)


Pls any help to increase speed?


Regards,
Moore

 

NauticalGent

Ignore List Poster Boy

Local time

Today, 07:19

Joined

Apr 27, 2015

Messages

6,321

• Jan 5, 2020

• #2

Hi there Moore,

Try this link:

https://www.fmsinc.com/MicrosoftAccess/Performance.html

 

vba_php

Forum Troll

Local time

Today, 06:19

Joined

Oct 6, 2019

Messages

2,880

• Jan 5, 2020

• #3

NG's is probably best, but if all else fails....

Why not look it up?

 

theDBguy

I’m here to help

Staff member

Local time

Today, 04:19

Joined

Oct 29, 2018

Messages

21,454

• Jan 5, 2020

• #4

Moore71 said:

Hi,
I have a solution being used by 2 users on a Lan/Wlan. Initially there wasn't any complain until recently they are complaining of too slow activities
I went there to check and you need to wait minutes for one process to perform
I change selecting Items from a ComboBox traditionally to using code to fetch data and I index almost every tables, but no valid result from that. I ask them to archive the data to start fresh entry but they reject that (It's a sales outlet)


Pls any help to increase speed?


Regards,
Moore

Click to expand...

Hi Moore. First obvious question: Are you using a "persistent" connection to the BE?

 

M

Moore71

DEVELOPER

Local time

Today, 12:19

Joined

Jul 14, 2012

Messages

158

• Jan 5, 2020

• #5

theDBguy said:

Hi Moore. First obvious question: Are you using a "persistent" connection to the BE?

Click to expand...

Please what do you mean by persistent connections?

 

theDBguy

I’m here to help

Staff member

Local time

Today, 04:19

Joined

Oct 29, 2018

Messages

21,454

• Jan 5, 2020

• #6

Moore71 said:

Please what do you mean by persistent connections?

Click to expand...

Check out this article. Hope it helps...

 

M

Moore71

DEVELOPER

Local time

Today, 12:19

Joined

Jul 14, 2012

Messages

158

• Jan 9, 2020

• #7

Thanks I have gone through the links sent to me and I am so grateful indeed because they all contributed to my search. I have sort out the issues
The application is relatively fast again now

 

jdraw

Super Moderator

Staff member

Local time

Today, 07:19

Joined

Jan 23, 2006

Messages

15,379

• Jan 9, 2020

• #8

Glad you have it resolved.
To assist others who may read this thread, can you tell us what you did specifically to get the speed back?

 

theDBguy

I’m here to help

Staff member

Local time

Today, 04:19

Joined

Oct 29, 2018

Messages

21,454

• Jan 9, 2020

• #9

Moore71 said:

Thanks I have gone through the links sent to me and I am so grateful indeed because they all contributed to my search. I have sort out the issues
The application is relatively fast again now

Click to expand...

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.

 

M

Moore71

DEVELOPER

Local time

Today, 12:19

Joined

Jul 14, 2012

Messages

158

• Jan 10, 2020

• #10

Hi,
These are what I did to have my Access Application speedup:
I opened the backend while the frontend were all closed,
I Repair and Compile the Backend as manually,
I re-indexed most fields that required search,
IWorked on my physical lan connections and,Installed ManageEngine_OpManager to monitor my network
That's all