by Garry Robinson

 

Notes on converting an ADP to an MDB/ACCDB

 

1. Create an empty MDB

 

2. Link all the tables, and views (these will appear as though they are tables even though they appear as queries in the ADP).  You may want to use the Group option so that you can work out what are queries and what are tables.

 

Note: For tables, you may want to Import Tables (or Copy and Paste)as this will turn tables into Access tables.  Open the adp and the mdb, copy and paste tables from the Tables tab or use the Import Wizard. You will probably loose all your keys and relationships in the process.

 

3. Create pass-through queries for all the stored procedures.  Only views will be imported and they will look like tables.  Queries will not import, you will need to manually move them across.

 

4. Then you would need to import the forms and reports and modules.  Check all the recordsource properties of forms as they may not work properly.

 

5.  Compile your database as your forms wont work until it is compiled

 

 This will probably not work as you will need to check all your references.

 

 One reference issue will probably whether you want to use ADO or DAO. ADO will probably be required as this was preferred in the ADP projects.

 

6. Check your startup processes are working  (Autoexec macro or Start Form).

 

7. You will probably need to do the import a number of times so document the process and build queries and systems to automate and test the process.

 

 

.

Note:  Be careful with the Name Auto Correct Property in the Tools ... Options .... General tab

 

Other Articles You May Want To Read
 
Access Data Projects - ADP
Everything About Using Parameters from Code