[AccessD] Connect to db with different wrkgroup

You can, but only in code, not in a query. 

Charlotte Foust

-----Original Message-----
From: Martin Kahelin [mailto:mkahelin at gorskibulk.com] 
Sent: Thursday, July 15, 2004 8:39 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Connect to db with different wrkgroup


I'm currently using Access 2003 with a 'new' mdw workgroup file.  I need
to lookup data from the 'old' Access database (v.2.0 format with mda
workgroup file) until I can port the old application and data over to
new database with data in SQL tables. -connecting to a SQL database I
can specify userid, password - I was hoping I can do the same to connect
to  another Access db/table.

> -----Original Message-----
> From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
> Sent: Thursday, July 15, 2004 12:16 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Connect to db with different wrkgroup
> 
> 
> 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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com