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.

There are several differences between MDB files and ADP files. The main difference is
ADP
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.

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.