copying Secured Database to another PC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there.
I have a slight problem as i am working on a database which is to be
implemented on another system and the only way i have of transferring the
database across is through a portably drive (effectivly a CD) i need to be
able to retain all of the data including the logon screen and all the user
rights as well.
Thanks Simeon.
 
Hi there.
I have a slight problem as i am working on a database which is to be
implemented on another system and the only way i have of transferring the
database across is through a portably drive (effectivly a CD) i need to be
able to retain all of the data including the logon screen and all the user
rights as well.
Thanks Simeon.
Click to expand...


You will have to transfer the database (the .mdb file) and the
workgroup security file (the .mdw file). The security files stores
username, passwords, groups and group affiliations; the database
stores the object permissions (i.e which users/groups can open/run etc
which objects). The "logon screen" will travel with the database.

Are you installing this with any type of installer? I ask because
you'll probably want to provide the user with a shortcut to open your
program with the correct security file - otherwise, when the user
opens your application they'll either be told they aren't using the
correct workgroup file, or will be able to open it directly with no
logon screen. If you use an installer, it could build a shortcut with
a Target something like this:

"Full Path To MSACCESS.exe" "Full path to your database" /wrkgrp "Full
path to your security file"

This will open your db with the correct security file, and will prompt
the user for their login. If you use an installer, you can set these
various paths at installation (so the user can install your program
anywhere they wish and it will still work). There are several free
Installers ... Inno Setup is one I used in the past which worked very
well.
 
Simeon said:
Hi there.
I have a slight problem as i am working on a database which is to be
implemented on another system and the only way i have of transferring the
database across is through a portably drive (effectivly a CD) i need to be
able to retain all of the data including the logon screen and all the user
rights as well.
Thanks Simeon.
Click to expand...

Take the mdb file(s) and associated mdw file, you will be OK.

Regards,
Keith.
www.keithwilby.com
 
This doesn't seem to work, I have used the wizard which created a shortcut on
the desktop and when i transfer the mdb and mdw it fails to bring up the
"logon screen"
And I am not using an installer as it is kind of a working progress which i
need to show work fairly regularly and therefore it is easier not to use one,
and i don't know how to anyway.
Thanks for you help so far.
 
As Scott said, you need to ensure that they start the database using a
shortcut of the following fom:

(all on one line)

"full path to msaccess.exe"
"full path to database file"
/wrkgrp "full path to workgroup file"

Just look at the shortcut that the wizard created for /you/ to use, on
/your/ PC. You need to create a shortu like that,m for /them/ to use,
on /their/ PCs. But each shortcut must have the correct path, for each
of the three relevant files on their PCs.

HTH,
TC
 
Back
Top