[AccessD] WORKGROUP FILES

You need to use the workgroup administrator to find out what workgroup is
set to default.  That is the workgroup that is used for Access in general.
To use a different one for a specific database, you can setup a shortcut
that uses the /wrkgrp flag to specify an .mdw other then the default one.

In Access 2003, it's in the Security section under Tools.  In 97 you had to
use wrkgadm (Start-->Run-->wrkgadm)

Drew

-----Original Message-----
From: JWColby [mailto:jwcolby at colbyconsulting.com] 
Sent: Friday, December 08, 2006 2:38 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] WORKGROUP FILES

I still need help figuring out what workgroup file a user belongs to and how
to join a different workgroup.  I am trying to test problems connecting to a
SQL Server source at my client.  My admin user can connect, users can't.  Si
I had them create me a "user" on my desktop that I can log into rather
logging in as the admin.  That works, but when I try to open any access
database, I get an error "database in use or no permissions" or something
similar.  It sure looks like an MDW problem, but I just can't figure out how
I discover the physical location of the mdw file that the admin user belongs
to, and then how to cause my new "user" to join that workgroup.  
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com