Help moving secured database

[Guest]

(Access 2002) I have secured a database using the wizard and have tried to
move it from my laptop to another pc (and will eventually move to the
network). I have copied across the folder that contained the database, mdw
file and wizard created shortcut to the datebase (appears to actually be a
shortcut to the secured.mdw file). I updated the Start in"

When attempting to open the database with the shortcut I got an error
message (which I can't duplicate and didn't note down ... doh!). Now when I
open the database it appears to open the mdw file only and not prompt for the
user name or login, and the database has items such as MSysGroupList in the
queries area and NO other objects.

Can someone please help with how I effectively move a secured database,
becuase my attempts have proved fruitless.

Thanks for any assistance.

I may not know VBA inside out, but from the outside I am looking in.
Dylan Moran - Melbourne Australia

 

[Guest]

Sorry, more thorough searching on google groups has found my solution.

Solution.

1. Copy the database and mdw file to their new location.
2. Create a new shortcut
3. Fill the Target: with the following
(noting the wif file may be name something other than secured.mdw)
(and if you have a split database the .mdb file is the front end)

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"\\servername\sharename$\directory(ies)\mydatabase.mdb" /wrkgrp
"\\servername\sharename$\directory(ies)\secured.mdw"


4. Fill the Start in: with

\\servername\sharename$\directory(ies)

Hope this helps anyone else out there.