Re: Security not clicking

Joan,
Your help is great, but would you please provide step by step process
of creating a shortcut on the network as well as securing the backend
and/or frontend.
The secured database is seated on my desktop. I copied it to a folder
in the network..successful, I also copied the mdw file to the same
folder....successful, however, I realised that the mdw file needed me
to import data..(is this normal?). At the same time, the mdw did not
show everybody shown on the one-step security wizard report...(is this
also normal?). If you have some links like the one you sent yesterday,
I would appreciate. I have to admit that it is the first time I am
securing a database on my own.
Thanks for your help so far.
Billy
Joan Wild wrote:
You need to copy the secure mdw and the mdb to a folder on the server that
everyone has access to. All users will need read/write/create/delete
windows permissions on that folder.

You can give each user a desktop shortcut the uses the secure mdw and opens
the secure mdb. The target would look like:
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

It is highly recommended that you split the database. Put the backend
(tables/relationships only) mdb on the server. A copy of the frontend (all
other objects, and table links to the backend) mdb would go on each user's
computer. You'd modify the shortcut above so that the path to secure mdb
would be the path to the frontend.

If everyone has Access installed in the same folder, and the frontend is
installed in the same location on each PC, you can copy the shortcut to each
person.

Since you've secured it, you shouldn't use the database splitter wizard, as
that will result in an unsecure backend mdb. Instead split it manually.

See www.jmwild.com/SplitSecure.htm



--
Joan Wild
Microsoft Access MVP

Billy wrote:
Everything seems to be going well at this point! Now how do I
distribute the database to the network or rather how do I create a
shortcut that can be accessed by everybody on the common drive?
Billy

.

Relevant Pages

  • Re: User access on a company intranet
    ... I did as you said and created a shortcut with the path you gave me and it ... I have built into my database should I disable this? ... When you want to implement security, you create a new mdw file, and follow ... to open the secure mdb is by using the mdw you created. ...
    (microsoft.public.access.security)
  • Re: Pointing to a pointer to an .mdb
    ... shortcut to the batch file. ... Users run the shortcut, the shortcut calls ... the .bat file, the btch file runs the .mdb file, access starts and it ... current database, which is full of valid data, with a new database ...
    (microsoft.public.access.formscoding)
  • RE: Workgroup Security
    ... I am going to make an .mde out of this database. ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... use it for that mdb. ...
    (microsoft.public.access.security)
  • RE: Workgroup Security
    ... I am going to make an .mde out of this database. ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... use it for that mdb. ...
    (microsoft.public.access.security)
  • Re: Multi users Logon Security questions
    ... > The next thing I need to do is split the database so others can work ... and navigate to the mdb - copy the mdb. ... You can use your desktop shortcut (which will open your frontend). ... Ctrl-O and open the backend mdb. ...
    (microsoft.public.access.security)
Loading