"Emma Hope" <EmmaH***@discussions.microsoft.com> wrote in message
news:CCAFA6F9-0D84-4624-A977-01536C35C649@microsoft.com...
> Hi All,
>
> I created a database about 12 months ago which is secured and split into a
> front end and a back end. I used a very helpful download from The Access
> Web
> (i think called AutoUpdater) to download a new copy of the front end to
> each
> user when i made changes to the server copy. Is a little "buggy" strange
> error messages appear at different times but it does the job and that's
> all i
> care about.
>
> Our IT infrastructure is quite appalling and my users in our Glasgow and
> London offices (the server and I are both in Birmingham) find the database
> runs incredibly slowly. Having tried many solutions, the only fix that
> works
> is for me to create a 'lite' version of the front end.
>
> Now i have two front ends and i want to use the program twice to create
> one
> set for my main users and one for my 'lite' users. However when i make a
> second copy and change all the parameters, it downloads what i want it to
> but
> the original which should download the original front end now downloads
> the
> 'lite' version as well.
>
> I tried to re-download this program from the Access Web so i could start
> all
> over again but it no longer seems to be available, is it possible for me
> to
> get this from somewhere else or is there another (free, sorry!) similar
> program that anyone can recommend that will do the same trick, preferably
> with as simple as possible interface.
>
> Thanks
> Emma
>

"Keith Wilby" wrote:

> "Emma Hope" <EmmaH***@discussions.microsoft.com> wrote in message
> news:CCAFA6F9-0D84-4624-A977-01536C35C649@microsoft.com...
> > Hi All,
> >
> > I created a database about 12 months ago which is secured and split into a
> > front end and a back end. I used a very helpful download from The Access
> > Web
> > (i think called AutoUpdater) to download a new copy of the front end to
> > each
> > user when i made changes to the server copy. Is a little "buggy" strange
> > error messages appear at different times but it does the job and that's
> > all i
> > care about.
> >
> > Our IT infrastructure is quite appalling and my users in our Glasgow and
> > London offices (the server and I are both in Birmingham) find the database
> > runs incredibly slowly. Having tried many solutions, the only fix that
> > works
> > is for me to create a 'lite' version of the front end.
> >
> > Now i have two front ends and i want to use the program twice to create
> > one
> > set for my main users and one for my 'lite' users. However when i make a
> > second copy and change all the parameters, it downloads what i want it to
> > but
> > the original which should download the original front end now downloads
> > the
> > 'lite' version as well.
> >
> > I tried to re-download this program from the Access Web so i could start
> > all
> > over again but it no longer seems to be available, is it possible for me
> > to
> > get this from somewhere else or is there another (free, sorry!) similar
> > program that anyone can recommend that will do the same trick, preferably
> > with as simple as possible interface.
> >
> > Thanks
> > Emma
> >
>
> I use batch files - simple and quick.  Here's an example:
>
> ECHO OFF
> DEL "%userprofile%\MyLocalFolder\*.*" /Q
> XCOPY "X:\MyPublicFolder\MyGUI.mde" "%userprofile%\MyLocalFolder" /I
> START "MyApp" /MAX "C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
> "%userprofile%\MyLocalFolder\MyGUI.mde" /wrkgrp  "X:\MySecurity\MyWIF.mdw"
>
> What it does is to copy the GUI into a known folder in the user's profile
> then launch Access and the GUI, referencing the appropriate security file
> where necessary.
>
> HTH - Keith.
> www.keithwilby.com
>
>
>

> Hi All,
>
> I created a database about 12 months ago which is secured and split
> into a front end and a back end. I used a very helpful download from
> The Access Web (i think called AutoUpdater) to download a new copy of
> the front end to each user when i made changes to the server copy. Is
> a little "buggy" strange error messages appear at different times but
> it does the job and that's all i care about.
>
> Our IT infrastructure is quite appalling and my users in our Glasgow
> and London offices (the server and I are both in Birmingham) find the
> database runs incredibly slowly. Having tried many solutions, the
> only fix that works is for me to create a 'lite' version of the front
> end.
>
> Now i have two front ends and i want to use the program twice to
> create one set for my main users and one for my 'lite' users. However
> when i make a second copy and change all the parameters, it downloads
> what i want it to but the original which should download the original
> front end now downloads the 'lite' version as well.
>
> I tried to re-download this program from the Access Web so i could
> start all over again but it no longer seems to be available, is it
> possible for me to get this from somewhere else or is there another
> (free, sorry!) similar program that anyone can recommend that will do
> the same trick, preferably with as simple as possible interface.
>
> Thanks
> Emma

"Joan Wild" wrote:

> It was likely Tony Toews' updater you have.  You'll find it here...
>  http://www.granite.ab.ca/access/autofe.htm
> However, you should also read
>  http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html
> as it sounds as though you are trying to run the mdb over a WAN.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Emma Hope wrote:
> > Hi All,
> >
> > I created a database about 12 months ago which is secured and split
> > into a front end and a back end. I used a very helpful download from
> > The Access Web (i think called AutoUpdater) to download a new copy of
> > the front end to each user when i made changes to the server copy. Is
> > a little "buggy" strange error messages appear at different times but
> > it does the job and that's all i care about.
> >
> > Our IT infrastructure is quite appalling and my users in our Glasgow
> > and London offices (the server and I are both in Birmingham) find the
> > database runs incredibly slowly. Having tried many solutions, the
> > only fix that works is for me to create a 'lite' version of the front
> > end.
> >
> > Now i have two front ends and i want to use the program twice to
> > create one set for my main users and one for my 'lite' users. However
> > when i make a second copy and change all the parameters, it downloads
> > what i want it to but the original which should download the original
> > front end now downloads the 'lite' version as well.
> >
> > I tried to re-download this program from the Access Web so i could
> > start all over again but it no longer seems to be available, is it
> > possible for me to get this from somewhere else or is there another
> > (free, sorry!) similar program that anyone can recommend that will do
> > the same trick, preferably with as simple as possible interface.
> >
> > Thanks
> > Emma
>
>
>

> Hi Joan et al,
>
> Thanks very much, you are right it was Tony Toews updater, i was
> looking totally the wrong place. However i need some more help if you
> or anyone else can help:
>
> I used the updater and set up two ini files for my two frontends, no
> problem, they validate successfully and run successfully (shortcuts
> created, frontend downloaded etc) on my own machine. However when i
> use the startmdb.exe on anyone elses machine, i get the following
> error message:
>
> Null command line sent to utility.
> If you are using a shortcut the the target in the the shortcut hasn't
> been properly setup. If you are using a bat or cmd file then the line
> calling this utility hasn't been properly setup. It should be in the
> folling format: StartMDB.exe / cmd /inifile: "z:\test\ini file
> name.ini" or
> StartMDB.exe / cmd /inifile: "\\server\sharename\ini file name.ini"
>
> This is the text from the ini file:
>
> [Settings]
> MainApp="H:\%User%\RO Tracker Database.mdb"
> Server="\\BPCISGBBH101\SharedData$\GFSL\RO Trackers\Front Ends\RO
> Tracker FE\" Lockout=No
> LockoutMsg=Sorry, not allowed into the system right now.
> SupportMsg=Please contact your Emma Hope 0121 450 6018 for support.
> CommandLine=/wrkgrp "\\BPCISGBBH101\SharedData$\GFSL\RO
> Trackers\Secured.mdw" ShortCutName=RO Tracker Database
> CreateShortCutOnDesktop=Yes
> CreateShortCutOnCommonDesktop=No
> ServerShortCutName=RO Tracker Database
> ShortCutIconFile="\\BPCISGBBH101\SharedData$\GFSL\RO
> Trackers\Icons\Ball.ico" QuickLaunchShortCutName=RO Tracker Database
> Shortcut Error Message Handling=2
> MDWFile=\\BPCISGBBH101\SharedData$\GFSL\RO Trackers\Secured.mdw
> MDWUser=hopee
> MDWPassword=(Password is encrypted)
> MDWPasswordEncrypted=D27EDAA256FB
>
> I don't understand what the error message wants to me to do, nowhere
> on Tony Toews site can i find anything that tells me to create a
> shortcut, so i believe the program is supposed to do this, so in this
> case, it must be the ini file that has something missing i presume,
> however it runs fine when i run it from my machine (master) but not
> on anyone elses, can anyone help me understand what i need to do.
>
> Thanks
> Emma
>
> "Joan Wild" wrote:
>
>> It was likely Tony Toews' updater you have.  You'll find it here...
>>  http://www.granite.ab.ca/access/autofe.htm
>> However, you should also read
>>  http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html
>> as it sounds as though you are trying to run the mdb over a WAN.
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Emma Hope wrote:
>>> Hi All,
>>>
>>> I created a database about 12 months ago which is secured and split
>>> into a front end and a back end. I used a very helpful download from
>>> The Access Web (i think called AutoUpdater) to download a new copy
>>> of the front end to each user when i made changes to the server
>>> copy. Is a little "buggy" strange error messages appear at
>>> different times but it does the job and that's all i care about.
>>>
>>> Our IT infrastructure is quite appalling and my users in our Glasgow
>>> and London offices (the server and I are both in Birmingham) find
>>> the database runs incredibly slowly. Having tried many solutions,
>>> the only fix that works is for me to create a 'lite' version of the
>>> front end.
>>>
>>> Now i have two front ends and i want to use the program twice to
>>> create one set for my main users and one for my 'lite' users.
>>> However when i make a second copy and change all the parameters, it
>>> downloads what i want it to but the original which should download
>>> the original front end now downloads the 'lite' version as well.
>>>
>>> I tried to re-download this program from the Access Web so i could
>>> start all over again but it no longer seems to be available, is it
>>> possible for me to get this from somewhere else or is there another
>>> (free, sorry!) similar program that anyone can recommend that will
>>> do the same trick, preferably with as simple as possible interface.
>>>
>>> Thanks
>>> Emma