Linking Access to Outlook

Is there a way to link say at table or query from access to the outlook taskings? Thanks

for 2007. sorry forgot to add that

Since the interface is different I'm not sure of the exact key clicks, but in 2003 it goes like this:

Menu File > Get External Data > Link Tables

This brings up a dialog box to select the file.

At the bottom of the box is the File Type selector

Choose "Outlook ()"
This will refresh the dialog box.

Navigate to the "Tasks", highlight and then click "OK"

TA-DA!

Ok thanks another question.
is there any code that needs to be added to the database to allow outlook to recognize the command. if so would you happen to have that handy.

That depends a lot on what you mean by "the command".

I don't remember if you can add records to the Tasks directly or not. If you can read all of the columns then you can add Tasks directly.

Otherwise to use VBA to add Outlook objects (calendar, tasks, etc) you need to add the Outlook reference library.

In the VBA code window on the Menu Tools > References
Which brings up the reference library dialog box.

I believe it is listed as: Microsoft Outlook xxxx

click the checkbox and then click OK

You can now use the Microsoft Outlook library.