Another Linking FE to SQL Server Question (1 Viewer)

I've found and tried code for cataloging all my linked tables and relinking them all to an SQL server, BUT what I need is something simpler, and I can't find how to do it.

Starting with a FE with no linked tables, all I want to do is link to every table in an SQL database where the table name starts with 'dbo'. I know the connection string details and the FE table name can simply be the same as the source table name. This is basically the same as doing it manually in the FE

As always, any help would be much appreciated

Thanks
Dave

http://hitechcoach.com/index.php?op...ge-your-linked-tables&catid=65:split-database
A frequent contributor to this site, he provided a nice webpage with some of the favorite links.
Enjoy

Thanks for that, but I couldn't find what I need. These programs seem to deal with re-linking whereas what I'm looking for amounts to first time linking.

Did I miss something?

Self-sorted. First I delete all linked tables on the FE. Then I use a pass through query to enumerate the tables on the SQL server, and then link them all to the FE using a bit of DSNless code from Microsoft.