Database is slow

[bratneedshelppls]

Hi,

I've designed a client database which I've saved on our server. I have 4 users. The database is very slow. I would appreciate some help please as to how to address this issue. The forms take a long time to load.

Thank you.

[ArviLaanemets]

How are users using the database?
Do they have their own front-ends in their computers or on LAN network resource?
Do they run the database from their computer in LAN, or do they do this over some remote connection?

[ranman256]

Have you compacted/repaired?

[CJ_London]

additional questions/comments:

Are fields that you sort/filter/join on indexed?
using domain functions in queries will slow things down
do you limit the form recordset on opening to just the records required? or do you bring through the whole table and filter afterwards? The latter will be much slower

[bratneedshelppls]

Hi Arvi,
They don't have their own front-end? Should I split the database?
If I split the database, do I add new forms to my own front-end and then given them each a copy of the new front-end?
The database is on a shared network drive. Two of us are working from the office and the other two are working from home at the moment.
Thank you for your help.
Tess

[bratneedshelppls]

Hi Ranman,
Yes, I have.

[bratneedshelppls]

Hi Ajax,
The fields are indexed.
How would I limit the form recordset on opening?
Everything is slow right from launching to the switchboard.
Thanks for your help.
Tess

[ArviLaanemets]

You HAVE to split the database! Every user MUST work with his/her own front-end. Front-ends may be copies of single front-end, but any user can have his/her own customized front-end.

For users working at home, my advice is to have for them Terminal Server Accounts with Access installed on TS. Home users log on into TS (e.g. using VPN connection), and start their front-ends from there.
An alternative is they have a desktop computers in LAN which are always working, and they are connecting to LAN using VPN and then log into work computer using RDP - and then starting front-end from there.

The main thing is, front-end and back-end must be in same LAN!