An ADP is a specific Access file type that stores user objects such as forms, reports, macros, and Visual Basic for Applications (VBA) code modules. All the other objects—the tables, stored procedures, views, and so on—are stored on the database server. It has its own advantages and disadvantages. Here the server is responsible for all query processing and fewer resources are needed at the client side. It can handle a large number of database users. On the other hand, one cannot create local tables or local queries. It is tied to one database engine and cannot be linked to multiple data sources.
We had a very good experience working on this project. We learned a lot about the differences between Access and SQL Server database. Not many code modifications were needed. Only DAO to ADO code conversion was applied throughout the application. Creating an ADP file was the best option we had for migrating the Access database to SQL server.
Amrita Dash
Mindfire Solutions