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

Jumat, 05 Juli 2019

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@schemesoftware.com [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, <strive4peace2008@...> 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