Numerous system.mdw files

[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

 

[Jeff Conrad]

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.

 

[Fred Boer]

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

 

[Immanuel Sibero]

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

 

[Jeff Conrad]

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!!!)

 

[Rick Brandt]

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.

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.

 

[Immanuel Sibero]

Oops, thanks for the correction, Rick!!


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


Immanuel Sibero

 

[Fred Boer]

Thanks! I knew that and had actually forgotten it.. thanks for the reminder.

Fred