[AccessD] MDW stuff

Hi JC,
You could either join a different Security Workgroup or create a new one.
Then, you may want to consider storing your MDW in the folder with your BEDB
and have your user's App shortcut add a specific MDW file in the startup
options. Here's an example of a shortcut string from my apps:

"C:\Program Files\Microsoft Access Runtime\OFFICE11\LaunchAccess.EXE" /excl
/runtime  /profile "MyApp"  /wrkgrp "N:\BEDB_Folder\system.mdw" "C:\Program
Files\WinHaven LLC\MyApp.mdb"

HTH
John B.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Tuesday, December 05, 2006 9:19 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] MDW stuff

I have always logged in to my PC at my client's using the administrator
username / password.  Now that I am no longer physically close to the
client, I have to troubleshoot "user problems" as a user instead of just
walking to a user's computer and looking at the problem.  So I asked the
client to set me up a jwcolby user, which they did, but when I try to get
into the database I get "database already in use or you don't have
permission...".  I suspect that a new MDW file was created and my new user
is using that, which prevents getting in to the database.
 
According to a KB article:
 
 By default, on computers that are running Microsoft Windows 2000, the
System.mdw file is created in the user profile in the following path. 

NOTE: The Application Data folder is a hidden folder. 
C:\Documents and Settings\<user name>\Application
Data\Microsoft\Access\System.MDW 
 
On my work computer there is no Access directory, and if I search for *.MDW
I find them at:
 
C:\Program Files\Common Files\System
 
and 
 
C:\Program Files\Microsoft Office\ Office
 
How do I determine which MDW is being used by the administrator user, and
then how do I force Access to use that mdw file for the new jwc user?
 
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