"misscrf" <mi*****@yahoo.com> wrote:
Keith, can you explain more about putting front ends for each user?
Why would you not just split the database and put a shortcut to the one
front end that is created, at each users end?
I ask because I am finishing up a project in the next couple of weeks
and I do plan to research splitting the db for best practices.
Any advice would be appreciated.
It is best practice to provide each user with their own FE. Some people
disagree with this and provide only one common FE but I would advise
against this since there is a danger of data corruption. A dedicated FE
also has a performance benefit.
There are a few different methods for providing users with a FE. I find
the simplest solution (assuming all users are on the same network) is to
use a batch file. The users' shortcut would point to the batch file which
would, in turn, copy the FE from a 'public' (read-only) folder to a
prescribed area on their local drive and then open it.
Typically, the batch file code might look something like this:
ECHO OFF
XCOPY "X:\MyPath\Public\MyGUI.mdb" C:\Temp\MyFolder /I
START "MyGUI" /MAX "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\Temp\MyFolder\MyGUI.mdb" /wrkgrp "X:\MyPath\Public\MyWrkGrp.mdw"
Of course, this assumes that C:\Temp\MyFolder exists but you can ensure it
does by sending all users a hyperlink to another batch file which prepares
their C drive accordingly.
HTH - Keith.
www.keithwilby.com