[AccessD] Connect to db with different wrkgroup

Jim Lawrence (AccessD) accessd at shaw.ca
Thu Jul 15 16:08:59 CDT 2004


Hi Marty:

Well, I have one suggestion and I will be having to do a similar task, next
week. Can you make the switch before or after hours?

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 11:48 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Connect to db with different wrkgroup


Thanks Jim - that would be ok except the data is live and is being
updated.  If I move it to a new table (v.2000) then the data isn't
accessible to the 2.0 app.  Oh well, nobody ever told me this stuff was
supposed to be easy.

> -----Original Message-----
> From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca]
> Sent: Thursday, July 15, 2004 1:38 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [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
>
> --
> _______________________________________________
> 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




More information about the AccessD mailing list