What's new in a Microsoft Access project
- Easily create a client/server application A Microsoft Access project (.adp) is a new type of Access file that provides efficient, native-mode access to a Microsoft SQL Server database through the OLE DB component architecture. Using an Access project, you can easily create a client/server application.
- Work with an Access project Working with a Microsoft Access project is very similar to working with an Access database. The process of creating forms, reports, data access pages, macros, and modules is the same. Once you connect to an SQL Server database, you can view, create, modify, and delete tables, views, stored procedures, and database diagrams using the Microsoft SQL Server Design Tools.
- Use Microsoft Data Engine (MSDE) MSDE is a new technology that provides local data storage compatible with Microsoft SQL Server 7.0. Think of MSDE as a client/server data engine alternative to the file server Microsoft Jet database engine. It is designed and optimized for use on smaller computer systems, such as a single user computer or small workgroup server.
- Upsize data and objects by using the Upsizing Wizard The Upsizing Wizard upsizes a Microsoft Access database (.mdb) to a new or existing Microsoft SQL Server 6.5 and 7.0 database or new Microsoft Access project (.adp) by upsizing the data and data definitions and migrating database objects.