[AccessD] WORKGROUP FILES

John, I don't understand what you're saying.  Are you having trouble
accessing Access tables *through Sequel Server* or logging into SQL
server, or logging into Access??  And why, oh why, are there multiple
workgroups like that for different users? Or is it multiple workgroups
for different databases?

Charlotte Foust

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