Can anyone show me how to add specific VB/VBA code to replicate the action of linking a particular table from an external database (particularly Oracle and SQL Server) within Access. I'm interested in programatically adding linked tables to my database, because the external databases to which I'm connecting have so many tables/views in their respective schemas that the attempt by the GUI connection dialog to read and return a selection list of all available tables/views just takes off and eventually times out.

Thanks in advance.

If you joined the AccessDevelopers group on Yahoo, in the demos section of Files there are examples of linking tables through code.

HTH,

Beth M