Can I Use Microsoft Access With Microsoft SQL Server Database Software And What Are The Advantages?

0 votes
asked May 27, 2017 in MS Access Issues by Sherry
retagged May 27, 2017
I have heard from somewhere that there are so many advantages of using MS Access with Microsoft SQL Server Database. Is it true? I just wanted to know what those benefits are. So, that I can take complete benefit of such. so, if anyone knows then please tell me?

1 Answer

0 votes
answered May 27, 2017 by lucy (980 points)

Undoubtedly, you can use SQL server database as a back-end for an access database application. In such case, Microsoft access forms and reports works as a front end and the SQL server tables, view and stored procedure works as a back-end SQL server database.  You can use either free version or the licensed version of the SQL Server database software. Problem with the free version is its smaller size limitation where as the licensed version have a very large size limitations of 524 PB (petabytes) for SQL Server 2008 R2.


•    Advantages of using SQL server database with access include scalability, increased database capacity and security. 
•  SQL Server is more scalable database technology that allows more Access database users while maintaining performance.  
•    SQL Server has more robust security which includes integrated windows based that make it more suitable as backend database choice where data security is an issue. 
•   MS Access has a database size limitation of 2 GB, whereas SQL Server has a minimum size limitation of 4 GB for the free version and unlimited capacity for the licensed versions. Therefore database size will get raised.
•  Besides this there are many more advantages of using SQL server backend with Microsoft access including, SQL Server Reporting Services, SQL Server Integration Services, .NET CLR Integration, etc.

Welcome to Q&A - Access Repair N Recovery, where you can ask questions and receive answers from other members of the community.