Linking Tables in External Database - Programatically

  • Thread starter Thread starter Karen B
  • Start date Start date
K

Karen B

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
 
Back
Top