[AccessD] Excel Automation problem

Thanks to everyone who answered! I'll let you all know if your
suggestions work. Unfortunately, I have to wait for access to that
machine to try them. I hope the reference order works - that's an easy
fix!

 
 
 
Cynthia Fraase
Asst. Controller
Direct: 678-325-3251
Cell:     770-318-0628
Fax:     770-641-2656
 
www.officeimagesinc.com
 
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Friday, April 20, 2007 1:23 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Excel Automation problem

This is the error very similar to when you have DAO36 selected but
DAO3.51 
is not on the machine at all.  I have found that downloading 
DAO350.dll...registering it...and everything is fixed.

Learned this after chasing down the error on 1 of 2 identical(so I
thought) 
machines.  The offending machine did not have 3.51 on it...I didn't have
it 
checked in references...so I never looked to see if it was there.  After

putting it on the machine/registering...the error went away.

There is a reference to it on MS site...but no explanation as to why it 
causes these errors, sometimes.

Good Luck,

Mark A. Matte