[AccessD] WORKGROUP FILES

Charlotte,

I didn't realize there were multiple workgroup files.  In fact I am not
absolutely certain that is the problem.  I have always, from the day I
walked in to the client, logged in as administrator.  If I needed to
troubleshoot a problem that a user was having, I went to a user's desk and
looked at it.  Now I live a thousand miles away and must remote in to
manipulate the database.

I am trying to get at data in a SQL Server database from Access.  I linked
the tables using odbc and logged in as my Admin user (of course).  I can
open the database and see the data in the tables.

USERS get an error IMMEDIATELY when they open the database.  I think it is
because of code that is trying to set up access to these tables, but I can't
be sure because I am not there. So...

I asked the client to set me up a "regular user" (jwcolby) on my normal
desktop machine (which is now locked away on a shelf in the server room,
serving just me for remote access).  My user can not even open a BE, FE,
library, NOTHING.  I get an error message "The Microsoft Jet Engine cannot
open the file c:\yadayada.  It is already opened exclusively by another user
or you need permission to view its data".  I can build blank databases just
fine with the new jwcolby user.

Sounds like an MDW/workgroup problem to me.

So... I am trying to determine what workgroup file is being used by the
ADMINISTRATOR user, where it is located, and how to join that workgroup by
the jwcolby user that is being denied access to everything.

Is that clear?

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Friday, December 08, 2006 5:10 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com