I use an access mdb on a Server based network running Server 2003. Both the front ends and the back end files are on the server. Six standalone workstations on the network use shortcuts to their individual front ends and all share the back end tables. Although the server and the PCs are very fast computers, I still experience long delays at times in working with the database. Any suggestions would be greatly appreciated.
2007-05-20 14:21:53 · 2 answers · asked by mainlandd 1 in Computers & Internet ➔ Computer Networking
Move your front end to local workstations.
How many users ?
How large are the MDBs ?
How are your lockings set up ?
2007-05-20 14:26:03 · answer #1 · answered by Cupcake 7 · 0⤊ 1⤋
Access really does not scale well. Meaning if more than four or five users are connected at the same time it will be slow. You might want to check Microsoft's Technical area for the details. SQL would be much much faster. Access was really built for local one user type or development and not for server production use.
2007-05-20 21:30:30 · answer #2 · answered by Tracy L 7 · 1⤊ 0⤋