Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 3rd, 2004, 02:38 PM
Registered User
Join Date: May 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default MDB vs. ADP files

I am upgrading an Access '97 DB to an Access 2003 DB and have a question regard .MDB and .ADP file.

1) What are the benefits and limitations with an .ADP file vs. a .MDB file.

2) Has anyone encountered any problems and work-a-round while up sizing the project that I should pay attention to.

3) Do I have to change anything if I up size the project.

Thanks for your help.

Old May 3rd, 2004, 05:53 PM
Friend of Wrox
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc

There are several differences between MDB files and ADP files. The main difference is
1.ADP - the data is stored in an SQL Server table.
2.changes made to the schema (data and structure)are made directly on the SQL Server.
3.Access project is called a project because it contains only code-based or html based database objects pages, macros, and modules.
4.Access project does not contain any data or data definition based objects.

You most like have to change the way your queries are designed, forms can stay the same way (as long as they are base on newly created procedures). Access project gives you a way to create an interface to your data with the full capabilities of access MDB reporting and form features.

Old May 4th, 2004, 07:10 AM
Registered User
Join Date: May 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks Jemacc,

I guess this would mean any table that exists in Access (i.e. tables to populate combo-box items) would have to be ported over into SQL and separate SQL queries would have to be constructed to retrieve those items.

Similar Threads
Thread Thread Starter Forum Replies Last Post
import data from mdb to another mdb mat41 Classic ASP Professional 3 March 9th, 2007 07:01 AM
adp slowness ginoitalo Access 1 November 6th, 2006 08:21 AM
Where is the processing done in ADP Scripts82 Access VBA 3 March 23rd, 2006 12:00 AM
MDB vs ADP, once again. leprechaun Access 1 August 5th, 2004 02:01 PM
ADP Menubar ginoitalo Access 2 April 11th, 2004 11:53 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.