[AccessD] Connect to db with different wrkgroup

I'm in the (slow) process of migrating data to Access 2000 format tables
and need help to bridge the transition.  With two Access databases (db)
having two workgroup (wg) files;
Is there a way to establish a query connection from db/wg A to db/wg B?
i.e. can I establish a sourcedatabase connection from a query and
specify mdb, mdw, user and password
-link doesn't work since the logged-in user or owner does not have
access to the other db.