Speed up data access

[Tom Ellison]

If you've truly done everything possible to optimize, then there are a
couple of alternative ways to speed it up:

- If the queries are fast when run directly on the server, use
Terminal Emulation so that all the applications are run directly on
the server only, instead of having instances of Access at each front
end. Or, change to a gigabit network.

- Keeping the data in a Jet database, install MSDE with the jet
database as a linked server and run all queries pass-through to MSDE.

Any tips to make a 25 user db run faster using the Jet engine?
I've cleaned up the controls and gone through optimizing from Microsofts
knowledgebase, but the data access is still slow.

Any suggestions?

thanks, Paul

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Paul Fetsch]

Any tips to make a 25 user db run faster using the Jet engine?
I've cleaned up the controls and gone through optimizing from Microsofts
knowledgebase, but the data access is still slow.

Any suggestions?

thanks, Paul

 

[Albert D. Kallal]

After how many users does it slow down? does it run well with 5 users? 10
users?

At what point does it become too slow?