ACCESS FEED: Re: [MS_AccessPros] database very slow on network

cabled connections are much faster than wi-fi

On 7/7/2019 3:27 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

hi Sarah,

it makes absolute sense! Access communicates with the back-end whereas other applications like Excel or Word don't usually have back-ends, so they wouldn't be affected by this.

It could be a cable going to YOUR computer that is bad (or other device). Are you on a local area network with cables, or a wide area network without them? It could just also be a bad connection ... maybe something isn't screwed in tight. Or maybe a cable is sharply bent.

And then, again, maybe it is something else -- but cabling and devices in between your computer and where the back-end is would be the first thing to check.

~crystal

On 7/7/2019 2:37 PM, sarahk@schemesoftware.com [MS_Access_Professionals] wrote:

Rob, thanks for your offer but my client will not agree for you to remotely connect.

Suggestions about cabling , wifi speed etc don't make sense if this is the only application on the network that is running so slow.

Sarah

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

thank you for your input, Rob -- and very generous of you to offer remote assistance. Perhaps if Sarah takes you up on that, you can share back to the group what needed to change? Nice to see you here!

have an awesome day,
crystal

On 7/7/2019 8:43 AM, Rob Koelmans r.koelmans@... [MS_Access_Professionals] wrote:

Oops, some Office or Windows10 mail filters seem to not like a word I just used.

??

Regarding the issue, if it would help (and practically doable), I can ask a specialized co-worker to assist you with teamviewer, anydesk, skype, remote assist atl.

Rob

??

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Sent: zondag 7 juli 2019 15:11
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] database very slow on network

??

??

It???s difficult te jump in because it???s an exclusion process. You start by checking the settings on both sides (type of cabling (Wifi??), speed settings, full/half duplex, auto negotiate going wrong, rx/tx-buffers settings, optimizations like jumbo packets/ packet size limitations like QoS), DHCP going wrong so traffic awaits time-outs all the time before choosing a secondary path or protocol, then protocol settings (unnecessary protocols like IPX/SPX, NetBEUI/NetBIOS, IPv6 or IPv4). Then address resolving slowness issues (Wins/Windows-DNS. Then traffic storms, faulty switches and network-cards, unconfigured devices on the network, detected/undetected wrong cable-configuring, then fileshare settings, self-referencing network paths in remote desktop, corrupted disk-i/o, overheated components trying to survive in not working cooling, cpu/memory load at both sides, corrupted/outdated malware stuff. It???s complicated.

Rob

??

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Sent: vrijdag 5 juli 2019 23:05
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] database very slow on network

??

??

hi Sarah,

I see no one else has jumped in. This is not the right forum to be asking about network speed, although some here may happen to know ...

You didn't mention if you are on a local area network or wide area network. A consideration is how much RAM (random access memory) your machine has. Increasing RAM is one of the best things you can do to enhance machine performance, but the problem could be how you are cabled if local area network, the speed of switches and routers between your machine and the machine with the data, and type of cable. Video cards also have memory to process screen images, and this is another way to increase performance.

To see your machine specs:
From Access or any Office product, click "About [Product]" from File, Account, and then System Info...

Sorry I can't be more helpful.

have an awesome day,
crystal

On 7/4/2019 1:05 PM, sarahk [MS_Access_Professionals] wrote:

The path is very short.

??I realize that local is faster, but the network is so slow, every screen takes a few minutes to load that?? I think it most be some setting on this network. I have installed on other networks and its fine.

Read something about 'Opportunistic locking in the windows file sharing layer ...', but its too technical for me.

??

??

Sarah

---In MS_Access_Professionals@yahoogroups.com, strive4peace wrote :

hi Sarah,

Local will always be faster. One thing you can do to enhance performance is to use a short path. Where is the drive physically located in relation to where you are? And do you know the path of the cables?

a couple suggestions to help performance:

Use short primary and foreign keys like AutoNumber/Long Integer as opposed to text fields with big Size

Build indexes on fields that are used for searching

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 7/3/2019 2:08 PM, sarahk@... [MS_Access_Professionals] wrote:

I just installed a new application: MS Access 2003, split. When I run it on a network drive it is extremely slow, but when I run the exact same application on the local drive it is very fast. I had to move the front and back end to the local drive, just moving the front end did not improve the performance. its a small db , less than 3MB for now.

??

What could be the reason?

??

??

All help is appreciated.

??

Thanks??

Sarah