Member Avatar for mshsoft
mshsoft 0 Newbie Poster

The Code in DAO to set a table link from one Mdb to another MDB is:
dim tb As TableDef
Set rdb = Workspaces(0).OpenDatabase("c:\db1.mdb")
' db1.mdb will contain the linked table
Set tb = rdb.CreateTableDef("newtable")
tb.SourceTableName = "newtable"
tb.Connect = ";DATABASE=c:\odb1.mdb"
'odb1.mdb contains real tables
rdb.TableDefs.Append tb

How can this be done in ADO.NET

  • 1 Contributor
  • 0 Replies
  • 89 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.