Linking Tables in External Database - Programatically

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Tables how do they work 3
Help with table setup for many-to-many/categories 3
Pivot Table List on Data Access Page - Linked Queries 0
Linking Access to selected fields in a large external table 1
Image linked to table 0
Event Database 1
Linked tabled Protect 1
Linked Tables - How to Close External Database? 11

Top