[AccessD] Connect to db with different wrkgroup

Charlotte Foust cfoust at infostatsystems.com
Thu Jul 15 11:15:40 CDT 2004


Not in a query.  You can't logically enable an interface-level
connection to a database where the user has no permissions on the other
database.  Why are you using two workgroups, and what is it you're
actually trying to accomplish?

Charlotte Foust

-----Original Message-----
From: Martin Kahelin [mailto:mkahelin at gorskibulk.com] 
Sent: Thursday, July 15, 2004 8:01 AM
To: Access Developers discussion and problem solving
Subject: [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.
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list