Linking Tables in External Database - Programatically

Hi all

I want to be able to link tables in Access 2000
using the on load event of my frmLink. The databases
I want to link are on our network on a shared drive (H)
and contain the teams call logs for the day. Each TSE
team has their own database, legacy design, which will
require a rewrite in the future but for now I am stuck
with it.
The tables for the four regions are identical and the
info I want to link to is contained in three tables
Exec_Id, Call_Id and Event_Log. The databases are
password protected and I want to be able to consolidate
the call logs and event history into a single supervisor
database

TIA

Karen

Hello. These two articles may help you out.

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

Always a good source - http://www.mvps.org/access/