By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,864 Members | 1,274 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,864 IT Pros & Developers. It's quick & easy.

Error: class does not support automation or does not support expected interface

P: 34
I've been using my access program all day and my co-worker is using it currently with no issues. I keep getting the error "class does not support automation or does not support expected interface". Can someone help?! It's an extremely busy time of year and I need this tool to complete my work. Thanks!
Jan 21 '15 #1
Share this Question
Share on Google+
3 Replies


jforbes
Expert 100+
P: 1,107
Is this error happing in code? If so, do you know what line and can you supply the code that is erroring out?

This error can occur when moving to a newer or different version of Office or Windows. Has either of them been updated recently?
Jan 22 '15 #2

P: 34
You have to forgive me as I'm not that familiar with Access. There is no 'Debug' prompt that appears and this database has been in use for years with no issues so I don't think its a coding error.

I updated to Access 2010 months ago but I've had no issues until yesterday and Excel has not been updated.

Just to give you a little more information the error occurs when the Access program tries to send the results produced to an Excel spreadsheet. This is working fine on a co-workers computer but mine will not let me view the results in Excel (and I'm not sure how to view them any other way). The Access program is very intricate and was designed by someone who no longer works for my company.
Jan 22 '15 #3

P: 34
I fixed this error! I just had to delete the .exd files from my C drive. I'm now getting a -1517 reserved error but only for one of the four Excel templates that we use. The other 3 are working just fine. This new error is happening across all computers (not just mine) and began before I fixed the error only occurring on my computer.
Jan 22 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.