using access 2000
how i can link a table from sql server by code?

Your best bet is to write this code in Access/VBA. The code creates a
DAO TableDef object and sets its various properties (connection
string, etc.) and appends it to the TableDefs collection. Here's a
sample where tdf represents a TableDef object:

Set tdf = db.CreateTableDef(strLinkName)
' Set the Connect and SourceTableName
' properties to establish the link
tdf.Connect = strConnectionString
tdf.SourceTableName = strSourceTableName
' Append to the database's TableDefs collection
db.TableDefs.Append tdf

--Mary

On Wed, 29 Dec 2004 16:44:35 +0200, "Sam" <focus10@zahav.net.il>
wrote:

>using access 2000
>how i can link a table from sql server by code?
>
>