Getting DB to users

[natalie]

Hi,
I think I have successfully used the security wizard and created a shortcut
to the db, which ended up on my desktop.
My problem is, how do I now get this secured shortcut to the other users? I
tried sending it via outlook, and it was blocked as a potentially harmfull
attachment. Now what do I do?

 

[Keith Wilby]

Hi,
I think I have successfully used the security wizard and created a
shortcut
to the db, which ended up on my desktop.
My problem is, how do I now get this secured shortcut to the other users?
I
tried sending it via outlook, and it was blocked as a potentially harmfull
attachment. Now what do I do?

Put your shortcut in a public folder and have users copy it from there, but
if you haven't already done so you need to split your database into
front/back ends, put your back end on the server and the front end on each
users' PC. The way I do it is to have a copy of the FE in a public folder
and have the users' shortcut run a batch file which copies the FE from the
public folder into their user profile and then launch it. The sytax is

ECHO OFF
DEL "%userprofile%\MyLocalFolder\*.*" /Q
XCOPY "X:\MyPublicFolder\MyApp.mdb" "%userprofile%\MyLocalFolder" /I
START "MyApp" /MAX "C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
"%userprofile%\MyLocalFolder\MyApp.mdb" /wrkgrp "X:\PathToMyBE\MyWIF.mdw"

Never having used the wizard I would recommend checking that you can't open
your app from a browser window.

HTH - Keith.
www.keithwilby.com

 

[natalie]

Thanks, Keith - I'll give that a try.

Put your shortcut in a public folder and have users copy it from there, but
if you haven't already done so you need to split your database into
front/back ends, put your back end on the server and the front end on each
users' PC. The way I do it is to have a copy of the FE in a public folder
and have the users' shortcut run a batch file which copies the FE from the
public folder into their user profile and then launch it. The sytax is

ECHO OFF
DEL "%userprofile%\MyLocalFolder\*.*" /Q
XCOPY "X:\MyPublicFolder\MyApp.mdb" "%userprofile%\MyLocalFolder" /I
START "MyApp" /MAX "C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
"%userprofile%\MyLocalFolder\MyApp.mdb" /wrkgrp "X:\PathToMyBE\MyWIF.mdw"

Never having used the wizard I would recommend checking that you can't open
your app from a browser window.

HTH - Keith.
www.keithwilby.com

 

[natalie]

One quick question:
Which database am I splitting? The shortcut on my desktop or the one I have
saved in my private file?

Natalie

 

[Joan Wild]

The one in your private file. The shortcut is just that - a pointer to the
mdb file.

Note you should NOT use the database splitter wizard, as that will give you
an unsecure backend, and secure frontend.

Instead split it manually. See
http://www.jmwild.com/SplitSecure.htm