[AccessD] Using ADO to change a TableDef? Mixing ADO and DAO?

All,

We have an existing Access 2007 application that uses ADO.

We now want to enhance this application to be able to change a TableDef
with VBA code so that we can change the path to an Excel file on the
fly.

Is it possible to change TableDefs with ADO?

I have seen many examples of how to change TableDefs with DAO, but I
have not yet discovered an example of how to do this with ADO.

I am fairly new to the world of Access and I am still trying to wrap my
little brain around the "ADO vs DAO" debate.

Is it Okay to mix both ADO and DAO in a single Access 2007 application? 

Thanks,
Brad