automatically creating table links in access to new tables in sqlserver database

  • Thread starter Thread starter Ruben Gouveia
  • Start date Start date
R

Ruben Gouveia

I created a new table in SQL Server. How can i get that table to show
up in my Access Database as a linked table automatically without
having to manually create the link in Access.

Thanks
 
On Fri, 18 Dec 2009 16:48:22 -0800 (PST), Ruben Gouveia

You can link tables programmatically. Look into the Connect property
as well as the RefreshLink method.

-Tom.
Microsoft Access MVP
 
Back
Top