[AccessD] Convert mdb to accdb Problem

Rocky Smolin rockysmolin at bchacc.com
Sat Apr 18 10:43:03 CDT 2009


Another oddity.  With fld Dimmed as Field, the Access 2007 compiler barfs on
fld.Name with "Method or data member not found" when compiling the accdb.
But it will compile the mdb.  Removing the reference to Word 12.0 library
eliminates the compile problem in the accdb.

Can anyone shed any light on this one?

MTIA

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Saturday, April 18, 2009 8:35 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Convert mdb to accdb Problem

So here's what I found:  it was the Microsoft Visual Basic for Applications
Extensibility 5.3 that was causing the problem.  The app opens fine with
that reference removed even with the Microsoft Office 12.0 Access Database
Engine Object Library referenced.

This is a massive application and so I'm going to let the client know what's
up and let him test all the functions.  But in general in 2007 what is lost
when you remove the VBAE 5.3 library?

And does anyone know if the DAO library is now part of the 12.0 Access
Database Engine Object?

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Saturday, April 18, 2009 7:27 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Convert mdb to accdb Problem

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
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.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