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

What kind of change do you want to make?  Wouldn't the path to the Excel
file be stored as data in a text field in the table?   

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, April 22, 2011 6: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