Getting DB to users

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

Guest

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?
 
natalie said:
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?
Click to expand...

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
 
Thanks, Keith - I'll give that a try.

Keith Wilby said:
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
Click to expand...
 
One quick question:
Which database am I splitting? The shortcut on my desktop or the one I have
saved in my private file?

Natalie
 
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
 
Back
Top