Concurrent Users Access 2007 (1 Viewer)

[martinjward]

I am trying to get a feel for how Access 2007 performs regarding the ammount of concurrent users using a database.

I know there has been a lot of differing opinions about previous version and was wonder is the new version of Access (& I would guess Jet as well) is more stable with multiple users?

 

[boblarson]

1. Use a frontend/backend split database (which you definitely should for multiple users)
2. The specs say you can have 255 concurrent users, but performance will slow down before that.

If you use the split database where EACH USER has a copy of the frontend on their machine, you should have no trouble. If you are like me and don't want to touch 100 machines, then you can use my Frontend Auto-Updating Enabling tool to be able to automatically update the frontends from a master that you will keep on the network.

You can find it here on my website:
http://www.btabdevelopment.com/main/AccessTools/tabid/78/Default.aspx