DWUTKA at marlow.com
DWUTKA at marlow.com
Tue Jul 27 18:27:51 CDT 2004
Sent it to you off list. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK Sent: Tuesday, July 27, 2004 5:54 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2K: WIN 98 machines are driving me crazy nope would love a copy of it I was about to write something in VB myself Yours would definitely be better DD ----- Original Message ----- From: <DWUTKA at marlow.com> To: <accessd at databaseadvisors.com> Sent: Wednesday, July 28, 2004 3:47 AM Subject: RE: [AccessD] A2K: WIN 98 machines are driving me crazy > Just perusing this thread. Darren, didn't I send you my VB Front End > updater? > > Drew > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK > Sent: Monday, July 26, 2004 11:30 PM > To: AccessD List > Subject: [AccessD] A2K: WIN 98 machines are driving me crazy > > > Hello all > I have some code that looks to the Back end of the app to determine if there > is a 'new' version of the app. > If there is a 'new' version then the app looks to a predefined place on the > server where the 'new' version is sitting > and it copies the 'new' version to the local machine. So for the current > session the user is using the 'old' version > but next time they spark up the app they are automatically using the 'new' > version Excellent. - on XP and WIN2000 at least > > Win 98 machines are not doing this. I am getting Permission denied errors. > Of course this is because the destination where I am copying the 'new' file > to is in use. > Obviously XP and WIN2000 open each dB in its own memory space and thus you > can copy underneath > but WIN98 does not. OK whatever.... > > So I thought I would just launch the app from the users desktop with a BATCH > file. > The batch file copies the new version each and every time (whether it's new > or not) then sparks up the app, > all from within the batch file Simple - on XP and WIN2000 at least > > Here is the batch file............... > REM START BATCH FILE########################################### > echo Updating your system to the latest Version of TruMan... > copy S:\Truman\Update\TRUMAN.MDB c:\Progra~1\Truman\Truman.mdb > c:\Progra~1\Truman\Truman.mdb > REM END BATCH FILE ########################################### > on XP and WIN2000 No Problem But when I run the BATCH file on a 98 machine I > get... > 1 file(s) copied (Great it copied the file) > Bad command or file name (Bugger it doesn't spark up the app) > > The S drive location of the new app is valid. The destination folder in > Program files and the existence > of the 'old' version is valid. (Remember this works on XP and WIN2000) > > The on the Win 98 machine if I copy the line " > c:\Progra~1\Truman\Truman.mdb" from the batch file and > clickon Start|Run and paste c:\Progra~1\Truman\Truman.mdb it sparks up the > app > as desired. So it works from Start|Run but not a batchfile?????!!!!!!! > > I'm stumped - any suggestions? > > Many thanks > > Darren > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com