Charlotte Foust
charlotte.foust at gmail.com
Fri Apr 22 10:35:20 CDT 2011
Yes, it is possible to change a table (not a tabledef, please note) with ADO, but you have to use the ADOX library, and the process is different. ADOX is the library that lets you create and edit tables using ADO. The 2010 help files aren't very helpful when it comes to ADOX, I've noticed. However, the MSDN files are better. Take a look at http://support.microsoft.com/kb/291264/fr to see about manipulating tables and links in ADOX. Charlotte Foust On Fri, Apr 22, 2011 at 6:31 AM, Brad Marks <BradM at blackforestltd.com> wrote: > 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 >