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

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
 
T

Tom van Stiphout

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Doughnut Chart linked with the slicer in the pivot table 0
List all tables, including document structure 0
Custom Ribbon Using SQLServer Backend 2
Shortcuts in OneDrive 0
Auto-Numbering in a Table in MS Word 1
Converting URLs in comments to Markdown-formatted links 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top