[AccessD] Convert mdb to accdb Problem

Doug Steele dbdoug at gmail.com
Sat Apr 18 09:35:48 CDT 2009


I just realized that when you open a 2003 database in 2007, you will get the
DAO library if you were using it in 2003.  If you then convert the 2003
database to 2007, Access replaces the DAO library with the Office database
engine library.

Doug Steele

On Sat, Apr 18, 2009 at 7:26 AM, Doug Steele <dbdoug at gmail.com> wrote:

> I tried this in Access 2007, and found that it works with the following
> references, in order:
> VBA
> MS Access 12.0 Object Library
> OLE Automation
> MS DAO 3.6 Object Library.
>
> If I try to add the MS Office 12.0 Access database engine... reference, I
> get the same message as you, and the message goes away if I remove the DAO
> library.  So they conflict.
>
> However, if I replace the DAO library with the Office 12.0 Access database
> engine library, the code starts working again.
>
> Doug
>
>
> On Fri, Apr 17, 2009 at 5:20 PM, Rocky Smolin <rockysmolin at bchacc.com>wrote:
>
>> Dear List:
>>
>> I converted an mdb to 2007 format - accdb. When I start the accdb I get an
>> error in code in the Open event of the opening form - 'type mismatch'.
>> It's
>> on the line
>>
>> For each prp in db.Properties
>>
>>
>>
>> prp is Dimmed as Property
>>
>> db is Dimmed as CurrentDb
>>
>> References are set to VBA, Access 12.0 Object Library, OLE Automation, CDO
>> for Windows 2000 Library (legacy app, you understand) , Calendar Control
>> for
>> 2007, Visual Basic for Applications Extensibility, Word 12.0 Object
>> Library,
>> and 12.0 Access database engine Objec (oops, ran off the side of the
>> References Dialog box).
>>
>> Am I missing a reference?
>>
>> MTIA
>>
>> Rocky Smolin
>>
>> Beach Access Software
>>
>> 858-259-4334
>>
>> www.e-z-mrp.com <http://www.e-z-mrp.com/>
>>
>> www.bchacc.com <http://www.bchacc.com/>
>>
>>
>>
>>
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>>
>



More information about the AccessD mailing list