DAO issue after converting to .accdb

[clancy76]

Hi all - I'm working on a legacy database that our client wants converted from an mdb to accdb. I did the conversion - everything seemed to go smoothly, until I ran some code that referenced the Fields collection of DAO 3.6 - specifically the "ForeignName" property. When I try to run the code, I get an error that states ""Method or data member not found"(code stops on the line that references the "ForeignName" property) . If I look at the properties and methods of the fields collection in the original mdb, the ForeignName is there, but it's not there in the accdb. I looked at my references for the mdb and the accdb, they're all the same. Anyone have any idea what might be going on? Thanks.

EDIT - disregard - the problem was that there is a fields collection the DAO library and the Word library, both of which were selected. Just moved the DAO library reference above the Word reference, works fine now, sorry to waste space.

[pbaldy]

Thanks for posting your solution, as it could help somebody later. Another solution may have been to disambiguate your declaration. In other words, instead of

Dim Blah As Whatever

you'd have

Dim Blah as DAO.Whatever

When you do that, the order of the references doesn't matter.

[clancy76]

Yup, your solution is definitely best practice, thanks pb.

[pbaldy]

No problem. As usual, there's more than one way to skin a cat (which the cat is not happy about).