Backup - Security Revisited

[Mark]

As you can see below, I made backup copies of my MDB & MDW
files and everything was good except when I try to access
the backup copy it never asks me for a password .. and
also wont let me into any of the objects. I tried the
below suggestions, but it still dont ask me for a
password. How can I fix this? Thanks!

My shortcut reads
C:\NPS-FMS.mdb /wrkgrp "C:\secured.mdw"

----------------------------------------------------

When you open the .mdb on your hard drive you need to make
sure you are using the backup .mdw file to open it.

You can accomplish this either by creating a shortcut for
the .mdb with a command line parameter for the security
file:

"<.mdb file path>" /wrkgrp "<.mdw file path>"

Or

Run the workgroup adminstrator program and join the .mdw
workgroup. Then open the .mdb file. Be sure to rejoin the
default workgroup before opening any other .mdb files or
you will have problems with permissions again.

Hope this helps,
Jean

-----Original Message-----
I have an Access database on a network and have
incorporated user-level security. It has been working
just fine & I have been backing up (copying) both the .mdb
and .mdw files to my hard drive.

However, when I try to open the .mdb file on my hard drive
(just as a test), it doesnt ask me for a password ... nor
does it allow me to access any of the objects (says I dont
have permission.

Guess I'm just looking for a method to access the backup &
reassurance that if I ever need to use the backup it will
actually work if I copy it back to the network location.
Thanks!
.

..

 

[Douglas J. Steele]

AFAIK, the shortcut needs to include the complete path to msaccess.exe as
well in order for subsequent command line parameters to be recognized.