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 >