Linking to another Access database's tables

pvp · Oct 28, 2003

If there a way to specify the path to the linked-to
database using VB?

Thanks.

John Nurick · Oct 28, 2003

Use the TableDef's Connect property. See e.g.
http://www.mvps.org/access/tables/tbl0009.htm

Linking data in MS Word into Excel	5	Oct 17, 2018
Access Lock File .LACCDB / Now shows as a notepad file	0	Oct 14, 2021
Linking tables	0	May 22, 2012
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...."	0	Oct 21, 2021
Converting URLs in comments to Markdown-formatted links	2	Dec 13, 2022
Help creating a search form in Access XP	0	Mar 4, 2022
Table Security in Access 2013	1	Nov 1, 2017
Linking Access and Oracle Database	2	Aug 26, 2010

Ask a Question