[AccessD] 203 vs. 2007

You're right.  When I create a new accdb the default references are:

VB for Apps
Access 12.0 library
OLE Automation
MS Office 12.0 access database engine object library.

So any references added will come after those.

When you convert from 2003 mdb to 2007 accdb, you get the order I originally
posted with the MS Office 12.0 access database engine object library
reference at the end of the list.  Which caused the problem.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Wednesday, July 22, 2009 9:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] 203 vs. 2007

My guess is that one of your other references has a 'Property' and a 'Field'
object which doesn't have a 'Name' property, and the fact that A2007 put the
DAO replacement reference below the other references causes the wrong (for
you) object to be used by default.

Doug

On Wed, Jul 22, 2009 at 8:19 PM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> Doug:
>
> Started over again with the mdb and converted to accdb to try your 
> suggestion.  That worked. What a screwy development platform.
>
> Thanks again.
>
> Rocky
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com