[AccessD] Convert mdb to accdb Problem

Max Wanadoo max.wanadoo at gmail.com
Sat Apr 18 11:39:10 CDT 2009


Rocky,
With all the problems you are having, here is what I would do.
1. Check that you have Versions 12 and not a mixture.
2. If 1. Is ok, then remove all the references and then compile.  As each
one chocks, look at what is hightlighted and the restore the reference for
that and then keep repeating this.  If at any time you add a new reference
and it chocks on the same code as the previous time, remove the last
reference added as that didn't cure the "current compile" problem (even if
you know you will  be adding it later).

Slow and painstaking but may overcome a lot of frustration now and maybe
further down the line.

Once it compiles ok, make a note of all the references and then go back to
the 03 version and compare.

It sounds as though you have incompatibility with reference clashing.

FWIW

Max


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

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

-- 
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