You can find here two directories with examples of databases and actions.

1. Database

Here are two samples of Access databases created with Microsoft Access Wizard :
- Contact2000.mdb for Access2000
- Contact97.mdb for Access97 

They both contain a table 'Contact' with some records in it.
You can use this database and this table with fields 'FirstName',
'LastName', 'ContactID' and phone numbers fields (WorkPhone, ...).

The two databases also contain a macro named "OpenContact" which opens the 
form 'Contacts' to display a contact record (see usage in third paragraph).


2. Action

You can find here three samples which can be used as external commands
for the Popup actions (open, close, create, show contact) when set in 
Access driver configuration ("Advanced"). Actually these simple programs 
only display the arguments passed to the command.

- action_bat.bat : Batch program
- action_vb.exe  : Visual Basic program
- action_vc.exe  : Visual C++ program

For example the command to enter in PIMphony configuration to use the 
VB program as an action is :
"<path>\action_vb.exe $1 $2 $3 $4" in the command line (where 
<path> is the full path where action_vb.exe program is located).
This command will display the phone number, the lastname, the firstname
and the contactID of the contact concerned by the action.

You can find the sources of Visual Basic program in the directory
sources_vb (project "actioncmd.vbp") and the sources of Visual C++ 
program in the directory sources_vc++ (project "actioncmd.dsp").


3. Microsoft Access actions

It is possible to launch an Access form directly to display a contact.
The previous examples of databases contain a macro called "OpenContact"
which opens the form "Contacts". This macro must be called with Access 
when executing the action (open contact). To do this you just need to set 
the launching of MSAccess with the macro OpenContact in the command line 
associated to the action. The key field ($4) is added as parameter of the 
macro to open the right contact record in the form.

For example the command to enter with Access97 is :
<path>\MSACCESS "<database_path>\Contact97.mdb" /x OpenContact /cmd $4