[AccessD] WORKGROUP FILES

John Skolits askolits at ot.com
Fri Dec 8 15:27:45 CST 2006


Can you just login as admin and run the command

? Syscmd(acSysCmdGetWorkgroupFile)

I have code that will retrieve all the uers in a group, providing you know
an admin username and password.

John



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Friday, December 08, 2006 3: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





More information about the AccessD mailing list