Speed up data access

  • Thread starter Thread starter Tom Ellison
  • Start date Start date
T

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
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
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
 
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?
 
Back
Top