[AccessD] Connect to db with different wrkgroup

Martin Kahelin mkahelin at gorskibulk.com
Fri Jul 16 13:48:38 CDT 2004


We all live for the priviledge to work after-hours - don't we?  Jim,
what do you have in mind?

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