[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
>