Are you getting any errors when you set up your connection? How are you
doing it, a connect string or a DSN?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Weatherman" wrote in message
...
Thanks Ken, it's something in my connection string. I am opening a
recordset
but it has a 0 count. I see that the query and table in access have
record
locks and I am not getting any errors in VBA. Outlook can pull data from
access so I can eliminate that a possable cause.