What reference is needed for TableDef object in Ac

问题:

I'm trying to use a macro/.mdb file that was written in Access 2003 in a new Access 2010 Access install. Opening my file I get a compile error saying the TableDef object is not able to be found. When I check my Tools->References menu I see Microsoft DAO 3.6 Object Library as available, shouldn't that suffice? Or is something else needed for the TableDef?

回答1:

The DAO library for Access 2007 and 2010 is Microsoft Office x.x Access Database Engine Object Library, not Microsoft DAO 3.6 Object Library.