Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / February 2006

Tip: Looking for answers? Try searching our database.

Tony Toews' Auto FE Updater - problem on other workstations

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
google@darincline.com - 14 Feb 2006 18:55 GMT
I'm having a problem with this that I can't seem to figure out.  I've
set everything up, I've gotten it to work correctly on MY system, and
now I'm ready to test it for other users.  When other users run the
exact same shortcut I do, they get the following error:

Start Error *************************************************

The Desktop shortcut  has the following for the first portion of the
Target:

'C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE'

when it should be:

'G:\GATRANE\StartMDB.exe'

The actual file is: 'C:\Documents and Settings\ts12d439\Desktop\Trane
Database'

---------- G:\GATRANE\UpdateTrnDB.ini--------------------

[Settings]

MainApp="c:\Program Files\TrnDB\FrontEnd.mde"

Server=G:\GATRANE\UpdateTrnDB

StartMethod=AutoSelect

CommandLine=/user %user% /wrkgrp G:\GATRANE\wrkgrp.mdw

MDWFile=G:\GATRANE\wrkgrp.mdw

MDWUser=AutoUpdate

MDWPassword=(Password is encrypted)

Lockout=No

LockoutMsg=Sorry, the database is currently down for maintenance.

SupportMsg=Please contact Darin Cline for support.

ShortCutName=Trane Database

CreateShortCutOnDesktop=yes

CreateShortCutOnCommonDesktop=no

ShortCutIconFile=G:\GATRANE\trnicon.ico

ShortCutIconFileIndex=0

MDWPasswordEncrypted=C43FD6A75EFB14D4

--------------------------------------------------------------------------------

Auto FE Updater Version: 1.69

Windows Version: Windows XP 5.1 build 2600 (Service Pack 1)

User: ts12d439

Workstn: WSTS12D439L

--------------------------------------------------------------------------------

End Error ****************************************************

Some google searching turned up a usenet post of someone having the
same error, and Tony replied that the problem was not passing the ini
file to the auto FE update exe file that the user should be running.
But in my case, I AM passing that.  Here is the exact shortcut that I'm
having the other user run:

G:\GATRANE\StartMDB.exe /cmd /inifile:"G:\GATRANE\UpdateTrnDB.ini"

As you can see, the "first portion" of the shortcut is the path to the
auto fe updater executable, but the error seems to claim that the first
portion is the ACCESS executable.  Ironically, I don't specify the
access executable ANYWHERE.  It's pulling that on it's own (which it
should, to determine what version of Access to run, but it shouldn't be
using that to install the front end on the user's computer).

Any ideas?

Thanks!
Tony Toews - 15 Feb 2006 01:20 GMT
>I'm having a problem with this that I can't seem to figure out.  I've
>set everything up, I've gotten it to work correctly on MY system, and
[quoted text clipped - 14 lines]
>The actual file is: 'C:\Documents and Settings\ts12d439\Desktop\Trane
>Database'

I suspect the problem is that your shortcut on the server has the same
name as an already existing shortcut on the users desktop.    So the
Auto FE Updater is telling you there's a problem with the users
desktop.

So, just to test this, change the following line in the INI file

ShortCutName=Trane Database

to read anything else.

ShortCutName=Trane Database testing

should work.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

google@darincline.com - 15 Feb 2006 18:55 GMT
Thank you very muc Tony!  The user I was testing with isn't in today -
she's home with her computer.  But I did test another user here in the
office, and it works fine, so the problem is specific to the machine,
not the ini or the software itself.  I spent so much time trying to
figure out what might have been wrong with the way I had things set up,
I didn't even look at detail at her machine, and it wouldn't have
occured to me that an identically names shortcut could have caused
this.  But now that you mention it, it is quite possible that she
already has a "Trane Database" shortcut.  We did have one, and now I'm
creating a new one, so she may have a left over shortcut.  I'll change
it to NEW Trane Database.  :-)

Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.