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

Brad,
I'm with you. Although after ten years working with Access, I still get
confused between ADO and DAO.
As a matter of preference, maybe because I don't understand the issues, I
routinely use DAO anytime I need to create a TableDef or anything else that
needs to connect to a database, etc.

Maybe someone on this list can give us definitions of the two and give
examples where one is better than the other.

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, April 22, 2011 8:31 AM
To: Access Developers discussion and problem solving
Subject: [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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com