Forum Discussion
lucsfar1a
May 18, 2022Copper Contributor
little question
hey guys, I just started an internship as a data analist and I'm wondering about if is worth it to switch from using acess to an SQL server. About the office that I'm working: Small investiment ...
isladogs
May 18, 2022MVP
SQL Server will provide additional security and stability which will be increasingly important if the number of concurrent users is more than 15-20
Access will allow up to 2GB file size but anything above 1GB or so may become slow and prone to corruption. The free Express version of SQL Server allows up to 10GB but as already stated, your app won't necessarily run faster unless configured properly
Access will allow up to 2GB file size but anything above 1GB or so may become slow and prone to corruption. The free Express version of SQL Server allows up to 10GB but as already stated, your app won't necessarily run faster unless configured properly