[AccessD] Convert mdb to accdb Problem

Max Wanadoo max.wanadoo at gmail.com
Sat Apr 18 12:49:35 CDT 2009


Doug, that is very good and may well be the answer. It come back to good
practices which is to fully define the parent of the object member.



Max



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

If you look at the object browser, there is a 'Field' object for DAO, Excel,
and Word.  The 'Field' object for Word doesn't have the member 'Name'.  If
your Word library reference is ABOVE the DAO/database library reference in
your reference list, then when you define a Field, it will be a Word field,
not a DAO field.  Try dimming field as DAO.Field and see if this fixes it.

Doug Steele

On Sat, Apr 18, 2009 at 8:43 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

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