Problems with .mdw

  • Thread starter Thread starter MB
  • Start date Start date
M

MB

Hello,

I'm going to start out by writing that I have already
downloaded the "MS Access Security FAQ" and have followed
that document to the letter. Unfortunately, I am still
having difficulties setting up multiple users over a
network.

The basic problem I am having is that after I use the
Security Wizard to set up all the users and specify a
specific drive in the wizard, Access will not link to
this .mdw file. Access instead will use the security file
that is on the C:/ drive of any individual computer
opening the database. If I delete this file, the db is
not accessable.

If anyone could give me an idea of where to go from here
that would be great!

Thanks
 
MB said:
Thanks Rick. I've been trying to create a shortcut using
the format that you gave me and it still doesn't seem to
be working. I am right-clicking the secured database and
creating a shortcut. After this I added the .mdw path by
going into Properties. Is this the correct method or
should I approach it in a different way? Thanks again for
the help...

If that's what you did, then you likely missed an important part of the
target. You need to put the path to msaccess.exe at the beginning of the
target, as well as adding the /wrkgrp "path to mdw" on the end of it.
 
Put your mdb and mdw closer to the root folder. You'll also avoid other
errors and improve performance.

By the way the target would look like (note the difference in the placement
of the double quotes)
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

eg.
"c:\Program Files\Microsoft Office\Office\msaccess.exe" "c:\db
files\mydb.mdb" /wrkgrp \\myserver\someshare\secure.mdw
 
To make things easier the mdw can be placed on the server and all users can
join this mdw. You need to join to the mdw yourself. Access will not do this
automatically.

Look for it in this directory for Access 2000: "C:\Program Files\Microsoft
Office\Office\1033\WRKGADM.EXE
 
Back
Top