Hi,

This is what I am trying to accomplish...

Table A --- SQL 2000
---------
Item (PK)
Path ---- This is the path where the access .mdf file exists

TABLE B --- Access 2000
--------
ID (PK)
ITEM

I want to query Table A to retrieve the path of table B then I want to use the path to Table B and query Table B to return a recordset based on my query.

I am trying to do this as a Package in DTS...

I am trying out a bunch of stuff.... any help would be appreciated..
Thanks in advance,

Alvin