Is the Access database can handle 60+ user?
Posted on 2008-11-03
I am thinking of creating Access 2003 database, which should be able to handle
Up to 64 User concurrent 70% read access and 30% write access
Up to 4Mil records divide in 2 databases (assuming 0.5K record)
Only 10 user will be on LAN connection to the database server and rest of the users will be on WAN.
- Choice of Access is right
- Access 2003/2007 will be able handle 64 users
- As Access database size is limit to 2GB, split the database in 2 file will do the job
- Access the MS Assess from WAN, is it adviable
Please suggest any other database for front and back end in not Access