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

microsoft access course - adp vs mdp

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

microsoft access course - Adp vs Mdp

ResolvedVersion 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:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.