Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ADP vs. MDB
- Thread starter tmorita
- Start date
An Access project (adp) allows bypassing the Jet Engine used with the MDB. ADP is designed for a client/server environment and uses ADO to connect to the Server Engine. From a client/server prespective it is cleaner and more efficient to bypass Jet and the ODBC layer associated with Jet that is required to link to a non-mdb server engine when you are developing an Access front-end application. In other words, an Access front-end to SQL Server should be an access project. If you are strictly working with Access only and not client server then an MDB file is fine. Also, once you become comfortable with ADO syntax and capability for data access, the same syntax is used in most front-end products especially Microsoft products like ASP pages and VB.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question