jlouija
asked on
Resolving error message when trying to connect Access 2007 to Outlook 2007
I used to be able to link an Access 2007 database to Outlook 2007 files with no problem. I started using the database again after about 8 months and now get "object or class does not support this set of events" message whenever I try to link or import. I have wiped and reloaded hard drive during that time, which may have something to do with it. Any thoughts?
ASKER
I am getting a "sub or function not defined error" It is in a part of the database I am not using right now and will take some time to fix. Is there a way to disable it for the time being?
You can comment out the code. The quickest way to do that is by showing the Edit toolbar, which includes the Comment and Uncomment methods. To do that, click View - Toolbars and select Edit.
Once you do that, highlight the code you wish to "remove", and click the "Comment Block" button on that toolbar.
Once you do that, highlight the code you wish to "remove", and click the "Comment Block" button on that toolbar.
ASKER
Thanks -- so I commented out that, compiled again, hit a couple other snags in unused segments of the database and commented them out as well. Now the Compile menu choice is grayed out.
That's good - means your code has compiled.
Now Compact the database, and see if you're still having troubles.
Now Compact the database, and see if you're still having troubles.
ASKER
Still getting object of class does not support event message. I created a new database from the Contacts template and get the same error message.
Can you describe exactly what you're doing when this occurs?
ASKER
in the External Data tab, More sub-tab, Outlook selection, it occurs when I try to import, append, or link to an Outlook folder
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
searching Internet on error message led me to a forum in which the problem was addressed and solved:
http://support.microsoft.com/kb/2687441
http://support.microsoft.com/kb/2687441
Make a backup before you do anything, of course.
You should also Compact the database after compiling.