Using External VB Application w/DAO to change links in an Access Database

[Jim Carlock]

I've seen this information before and perhaps I've even asked it
before, ages ago. It's just not sitting right there in the formost part
of my head.

I'm looking to use a VB created program to programatically
change linking information in an Access database.

I'm thinking along the lines that it's done with a tabledef.

Anyone have a link to a sample. I've searched the help file for
"linked tables" and am doing some searches, but I haven't found
a solution yet.

I'm using DAO.

Thanks in advance.

 

[Graham R Seach]

Jim,

This may be what you were thinking about:

http://www.mvps.org/access/tables/tbl0009.htm

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia

 

[Jim Carlock]

Ahh yes, it's the Connect property of a .TableDef that holds the string.

Thanks Graham!

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


Jim,

This may be what you were thinking about:

http://www.mvps.org/access/tables/tbl0009.htm

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia