MS Access ODBC Connections

[KenHigg]

May find help here:

http://www.connectionstrings.com/

or copy from a working linked table.

Cool Link - Thanks

 

[mlr0911]

Is there a way to relink multiple tables instead of one at a time? I created a list box (works well with a combo box)that is querying Mysys objects; I would like to be able to select more than one table at a time to relink and refresh. The code above works like a charm doing 1 at a time. I was just wondering if anyone had any idea how I could refresh all of my tables..

Thanks

 

[pbaldy]

You should be able to get the table name in your multiselect loop and substitute it here:

Set tdf = CurrentDb.TableDefs("tblimport")

 

[mlr0911]

Paul, that's what I have done with the combo box. Will it still work with a list box with multiple items selected.

Thanks again for all your help.

 

[pbaldy]

Sure, but it would have to be within the multiselect loop. What do you have so far?