[AccessD] Connect to db with different wrkgroup

Hi Martin:

Have you tried to link the data. Go into the new database and select link
(File/Get External data/Link Tables...) to attach the tables from the older
database. You should be able to actually copy the old tables, with data,
into new tables, into the new database. Later, when the SQL DB is up and
running you can just pull the tables and data, into the DB using the DTS
import/export wizard, in the EM.

This should be a very easy process...but you will have to have full
permissions.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Martin Kahelin
Sent: Thursday, July 15, 2004 9: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