jack drawbridge
jackandpat.d at gmail.com
Fri Apr 22 10:44:52 CDT 2011
Here's a link to some ADO examples and tips by Allen Browne. http://allenbrowne.com/func-adox.html Specific to Modify table is http://allenbrowne.com/func-adox.html#ModifyTableAdox On Fri, Apr 22, 2011 at 11:35 AM, Charlotte Foust <charlotte.foust at gmail.com > wrote: > 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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >