[AccessD] vba sql connection question

Hello list,

I need to write some VBA code that establishes sql table connections
on the fly when the mdb is connected and then assigns the new table to
a from so the user can interact with it. The connection can not use
dsn and it is to a remote server on the web.

Thank you very much for all your help.