Connecting Tech Pros Worldwide Forums | Help | Site Map

Tony Toews Auto FE Updater Problem

darren via AccessMonster.com
Guest
 
Posts: n/a
#1: Apr 11 '06
Hi I'm trying to use the Auto FE updater for the first time and am running
into a few problems.

1) 'UNC names on client path 'path' currently not supported.' I've mailed our
helpdesk to see if this is a netwrok thing but have not had a response. I am
sure in the past that they said UNC's were not a problem.

2) In the meantime I tried using a local address/ini just to see it I could
set it up. The local ini file passed validation but then I get another error
message:

"Error Copying File Or Folder" _
"Cannot copy AutoFEUpdater: It is being used by another person or program" _
"Close any programs that might be using the file and try again" _

When I click OK, it just opens the database.

I have tried removing AutoFEUpdater and starting from scratch but get the
same message.

Any assistance welcome.

Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1

darrensawyer via AccessMonster.com
Guest
 
Posts: n/a
#2: Apr 11 '06

re: Tony Toews Auto FE Updater Problem


I'm having a very blonde day, been working to hard.

OK, update, got past this and now have new questions:

1) In the ini file MainApp= the workstation FE address? If that's true then
do I need an ini file for each FE or have I missed something??

2) On the users workstation I belive I'm setting the shortcut to StartMDB.exe
but need to make it run the ini.file. Can someone give me an example to work
from. (I've not tried the cmd before)

Thanks

--
Message posted via http://www.accessmonster.com
darren via AccessMonster.com
Guest
 
Posts: n/a
#3: Apr 11 '06

re: Tony Toews Auto FE Updater Problem


Like I said.... blonde day.

Got it working.

darrensawyer wrote:[color=blue]
>I'm having a very blonde day, been working to hard.[/color]

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1
Jeremy Wallace
Guest
 
Posts: n/a
#4: Apr 11 '06

re: Tony Toews Auto FE Updater Problem


Darren,

Wanna post your errors and solutions here? Then when someone runs into
the same problems they'll also see the solutions...

Jeremy

darrensawyer via AccessMonster.com
Guest
 
Posts: n/a
#5: Apr 11 '06

re: Tony Toews Auto FE Updater Problem


No Problem.

Initially I had incorrectly set the MainApp to the master FE, instead of the
User FE. This sorted out the first set of issues.

The next ones relate to the shortcut, I did not enter the path for the ini
file.
e.g. StartMDB.exe /cmd /inifile:"c:\test\ini\startmdb.ini"

Individual ini's are not required for each user if you use some generic path
for their copy (MainApp)
e.g. c:\DatabaseName.

This path should work for all as long as the system administrators allow
writing to the c:drive of the workstations.

Hope this is of use. The bottom line is I should have read Tony's text a
little more carefully before rushing in..


Jeremy Wallace wrote:[color=blue]
>Darren,
>
>Wanna post your errors and solutions here? Then when someone runs into
>the same problems they'll also see the solutions...
>
>Jeremy[/color]

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1
David W. Fenton
Guest
 
Posts: n/a
#6: Apr 11 '06

re: Tony Toews Auto FE Updater Problem


"darrensawyer via AccessMonster.com" <u11419@uwe> wrote in
news:5ea011a0f0597@uwe:
[color=blue]
> The next ones relate to the shortcut, I did not enter the path for
> the ini file.
> e.g. StartMDB.exe /cmd /inifile:"c:\test\ini\startmdb.ini"
>
> Individual ini's are not required for each user if you use some
> generic path for their copy (MainApp)
> e.g. c:\DatabaseName.
>
> This path should work for all as long as the system administrators
> allow writing to the c:drive of the workstations.[/color]

It would be better to use something like %USERPROFILE% for the
location of the front end. That will always be writable whether or
not the user is an administrator (which they should never be in a
secure environment).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
darrensawyer via AccessMonster.com
Guest
 
Posts: n/a
#7: Apr 12 '06

re: Tony Toews Auto FE Updater Problem


Hi David

Ini files are all new to me but I think I get where you are coming from. I'll
investigate further.

Thanks

[color=blue]
>[/color]

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1
David W. Fenton
Guest
 
Posts: n/a
#8: Apr 12 '06

re: Tony Toews Auto FE Updater Problem


"darrensawyer via AccessMonster.com" <u11419@uwe> wrote in
news:5ea91f4a0b6b7@uwe:
[color=blue]
> Ini files are all new to me but I think I get where you are coming
> from. I'll investigate further.[/color]

The use of the environment variable is not an INI file issue. Simply
replace the path you're using with the environment variable in the
value stored in the INI file, and it should work (you'll have to
test whether the variable has a trailing backslash). To concatenate,
you just do something like "%USERPROFILE%\AccessFiles\" which when
it runs will replace the variable with the stored environment
variable.

This is simple old-fashioned DOS batch file technique.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
doctorle@hotpop.com
Guest
 
Posts: n/a
#9: Apr 14 '06

re: Tony Toews Auto FE Updater Problem


Everyone should check this out: a beautiful solution by Danny
http://www.databasejournal.com/featu...le.php/3286111



darren via AccessMonster.com wrote:[color=blue]
> Hi I'm trying to use the Auto FE updater for the first time and am running
> into a few problems.
>
> 1) 'UNC names on client path 'path' currently not supported.' I've mailed our
> helpdesk to see if this is a netwrok thing but have not had a response. I am
> sure in the past that they said UNC's were not a problem.
>
> 2) In the meantime I tried using a local address/ini just to see it I could
> set it up. The local ini file passed validation but then I get another error
> message:
>
> "Error Copying File Or Folder" _
> "Cannot copy AutoFEUpdater: It is being used by another person or program" _
> "Close any programs that might be using the file and try again" _
>
> When I click OK, it just opens the database.
>
> I have tried removing AutoFEUpdater and starting from scratch but get the
> same message.
>
> Any assistance welcome.
>
> Thanks
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...ccess/200604/1[/color]

Closed Thread


Similar Microsoft Access / VBA bytes