splitting db & shortcuts

A

Abbey Normal

Hello all. I'm getting ready to split a multi-user database. Currently their
shortcuts point to G:\Parts\Parts.mdb/ wrkgroup "g:\Parts\security.mdw. Once
I've split it, I point the shortcut to the front end, right? which should now
be on their C drive. and will it be okay to have the workgroup still on the
network drive(G). THe workgroup is still necessary, right, since I still want
some users as read-only access? Thank you for your help.
 
V

Van T. Dinh

Everything sounds correct to me.

Are you just confirming or you having problems with the new (split) set-up
of your database application).
 
J

Joan Wild

Abbey said:
Hello all. I'm getting ready to split a multi-user database.
Currently their shortcuts point to G:\Parts\Parts.mdb/ wrkgroup
"g:\Parts\security.mdw. Once I've split it, I point the shortcut to
the front end, right? which should now be on their C drive. and will
it be okay to have the workgroup still on the network drive(G). THe
workgroup is still necessary, right, since I still want some users as
read-only access? Thank you for your help.
Click to expand...

Do not use the database splitter to split the secure mdb - the frontend will
be secure, but the backend won't. Split it manually. See
http://www.jmwild.com/SplitSecure.htm

Otherwise, yes you change the shortcut to point to the frontend on their C:
drive. You could use UNC pathname for the mdw file on G:. That way you
don't have to rely on correctly mapped drives. Also the switch is /wrkgrp
not /wrkgroup. Also there should be a space before the / and not one after
it. And you need the full path to msaccess.exe in the shortcut or it won't
work. So it should read

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" "c:\path to
frontend" /wrkgrp "\\servername\share\security.mdw"

Change the path to msaccess.exe to what it is on the users' machines.
 
A

Abbey Normal

yes, I am just confirming. THanks for the recommendations. Esp. about
splitting the DB manually, which seems to be more understandable than using
the splitter -- except that it looks like it doesn't know what to do with
file that are already linked to an external source(as/400). I'm assuming I
would have to re-link them.
 
J

Joan Wild

Abbey said:
yes, I am just confirming. THanks for the recommendations. Esp. about
splitting the DB manually, which seems to be more understandable than
using the splitter -- except that it looks like it doesn't know what
to do with file that are already linked to an external
source(as/400). I'm assuming I would have to re-link them.
Click to expand...

Yes.
 
Top