tailieunhanh - access 2007 vba bible phần 10

nhưng nó thiếu hỗ trợ cho các tính năng doanh nghiệp. Nếu bạn cần để tạo ra một ứng dụng doanh nghiệp, bạn sẽ cần một trong các phiên bản khác của SQL Server 2005, nhưng để sử dụng cá nhân hoặc kinh doanh nhỏ, SSE là rất phù hợp. | Working with SQL Server Data 18 If you don t have SQL Server 2005 installed you can download the Express version free from http vstudio express sql . Compared to the full version SQL Server 2005 Express SSE has a number of limitations but it is fine for experimenting with SQL Server as a back end or developing small applications. SSE includes all the core database features of SQL Server 2005 but it lacks support for enterprise features. If you need to create an enterprise application you will need one of the other editions of SQL Server 2005 but for individual or small business use SSE is very suitable. For a full comparison of the features of the five editions of SQL Server 2005 see the tables here sql prodinfo features compare- . SSE is an upgrade to the Microsoft Database Engine MSDE which was included in the higher-end editions of previous Office versions. Compared to MSDE SSE has several enhancements The maximum database size has doubled from 2GB to 4GB. MSDE s limitation on the number of concurrent users to five with performance degrading significantly if there were more users has been removed. The SQL Server Management Studio included with SSE gives you a user-friendly interface for working with saved queries and stored procedures as well as various administrative tasks. The new XCopy deployment feature allows you to copy a database file to another computer even if the database is not open. Other users can then connect to the database copy using the AttachDBFileName connection string argument. SQL Server 2005 must be upgraded to Service Pack 2 to work with Access 2007. If you have an earlier version when you first run SQL Server 2005 or attempt to connect to it you will get a message advising you of the need to upgrade with a reference to a web page with the SP2 upgrade links for both SQL Server 2005 and SSE. Preparing an Access Database for Upsizing to SQL Server To convert an Access database or just its .