microsoft access course - adp vs mdp

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access course - Adp vs Mdp

microsoft access course - Adp vs Mdp

resolvedResolved · Low Priority · Version Standard

Clare has attended:
Access Introduction course

Adp vs Mdp

Hi

Can you tell me the difference between these two file types in access? All the work I did in the course ended in Mdp but when I have come to look at all the databases we have at work, they all seem to be adp.

Thanks

Clare

RE: Adp vs Mdb

Mdb (Not Mdp) is the normal Microsoft Access Database.

Adp is a Microsoft Access Project file.

An Access project contains only HTML-based (Web) database objects: forms, reports, the name and location of data access pages, macros, and modules.

An Access project does not contain any data eg tables.

To create your application and access the data, you must connect the Access project to a SQL Server database


 

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips


Server loaded in 0.11 secs.