Numerous system.mdw files

  • Thread starter Thread starter Fred Boer
  • Start date Start date
F

Fred Boer

Hello:

I am (once again) working on implementing security for my application, and
it's going fine (really!). A quick question: there appear to be numerous
system.mdw files sprinkled around on my hard drive. It appears that
different system.mdw files are created for different log-ins (i.e.
"Administrator" has one, "boerfr" has one, there's one in
windows\system32,..). These can safely be ignored, right?

Thanks!
Fred Boer
 
Hi Fred,

Yes, the other system.mdw files are fine.
One machine in front of me has six of them.
They are created for different profiles just as you guessed.
Don't remove any of them though.
 
Thanks, Jeff!

Just installing Access 2003 on my machine as we speak... Network upgrade to
Windows 2000/Office 2003 is taking place over holidays...

Fred
 
Hi Fred,

You can determine which workgroup file (.mdw) you are using.

For Access 2000 and older, do the following:
From the desktop, Start>>Run>>wrkgadm, click OK. This will tell you the .mdw
file you are using.

For Access 2002/XP and newer, do the following:
In Access, Tools>>Securities>>Workgroup Administrator . This will tell you
the .mdw file you are using.


So, can you safely delete the .mdw files?
Well, obviously the ones you are using (determined per above steps) are not
safe to delete. As for the other .mdw files, you would need to determine if
they are ever used or not.


HTH,
Immanuel Sibero
 
Sweet.
Sounds good Fred.

Upgrades?
Everything should go really smooth; no problems at all.
Right............

(Back up ALL of your files to CDs today and take them home with you!!!)
 
Immanuel Sibero said:
Hi Fred,

You can determine which workgroup file (.mdw) you are using.

For Access 2000 and older, do the following:
From the desktop, Start>>Run>>wrkgadm, click OK. This will tell you the ..mdw
file you are using.

For Access 2002/XP and newer, do the following:
In Access, Tools>>Securities>>Workgroup Administrator . This will tell you
the .mdw file you are using.
Click to expand...

Slight correction. That tells you what your default mdw file is. This is
not necessarily the one currently being used if you started Access with the
/wrkgrp command line argument.
 
Oops, thanks for the correction, Rick!!


The currently used workgroup file can be determined by:
? application.DBEngine.SystemDB


Immanuel Sibero
 
Back
Top