Conncting Access reprt to two .MDB databases 1

[Avacha]

I have two Access dabeses, inside one of them I have access report and I need to connect second database to that Access report in the first database. If anyone knows
how to do it or give me reference on what to read I would greatly appreciate your help.

 

[JoanneM]

Hello Avacha
Link the tables that supply the data for the report

In the database window on the top menu bar

select File

then getExternalData
then select Link

then link it to the other Access database table you need

regards

Jo

 

[Avacha]

Jo,
Thank's. I appreciate.

 

[JoanneM]

Avacha

Nb
Linked table structure cannot be altered from your reports
database only in its own container data base
but data can be added, edited and deleted from the tables from the reports DB.

As this is new to you TAKE COPIES AND BACKUP or there will be tears before bedtime!!!



regards

Jo