[AccessD] Connect to db with different wrkgroup

Some neat-freak cleaned out the safe and threw out the notes on the .mda
keys so I should not be able to re-create the file - conspiracy to have
me committed.

> -----Original Message-----
> From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] 
> Sent: Thursday, July 15, 2004 10:42 PM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Connect to db with different wrkgroup
> 
> 
> WG files?  In 97 and 2000, workgroup files are mdw's, did 
> that change in 2003?
> 
> One approach you might take is to 'merge' the security 
> systems.  Workgroup files only store 'login' information, the 
> permissions are stored in the .mdb itself.  If you use the 
> same UserName and/or Group name, in both workgroup files, 
> they should be interchangeable.  Of course, you also have to 
> use the same 'ID' when you create them.
> 
> I honestly don't know how well it works across versions.  I 
> would assume that going from a newer version to an older 
> version wouldn't be an issue. 
> 
> If you have the security matched, I don't think you would 
> have a problem putting a 'outside' database as a source in a 
> query.  I'm guessing here, but it's a well educated guess.  
> Access User Level security is very similar to NT security, 
> and when a process in NT has a specific security account, the 
> 'credentials' carry over to whatever that process is using.  
> I wouldn't be at all surprised if Jet does the same thing.
> 
> Drew
> 
> -----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: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
>