Just A Question..

[rosh41]

Hi,


Does an access db allow 6-8 people to work simultaniously on the same tables? Db will grow to about 800MB in size over next few years.
How will transaction speeds be affected when used as a front-end with sharepoint or sql server?

[Rawb]

Access can certainly allow for multiple users. If you're using a native Access database, just use a Split Database. If you're using Access as just a front-end for some other SQL backend (MS SQL Server, etc.), you don't have to do anything. You'll also want to make sure Access is configured for either "No locks" or "Edited record" if the users will be in the same table.

Transaction speed should be fine unless you're using a low-speed network connection like a WAN/VPN to connect to the backend. Access wasn't designed for that kind of environment so you'd be better off writing a web-based or similar application instead of using Access.