Re: Replacing backend database

From: FPS, Romney (fpswv_at_citlink.net)
Date: 02/04/04 

Date: Wed, 4 Feb 2004 13:25:16 -0500

Thanks Nikos for the response. However, do you know the VB code to do a
Windows copy command from within the database? (I'll want to replace the
existing file without prompting).
Thanks,
Mark

"Nikos Yannacopoulos" <nyannacoREMOVETHISBIT@in.gr> wrote in message
news:%23F7WI3x6DHA.2480@TK2MSFTNGP10.phx.gbl...
> Mark,
>
> If you have VB you can make a small .exe that does the file work and then
> launches the database. If you don't, you can even use a plain
old-fashioned
> command prompt batch file to do the same... they still do the job!
>
> Whichever way you go, I would suggest you add an extra line in there to
make
> a backup copy of the back end on the home PC before the newer version from
> the floppy overwrites it... floppies are floppies. Actually, I'm surprised
> you still use them. You should consider USB flash disks; once you've tried
> one, you won't be able to live without it!
>
> HTH,
> Nikos
>
> "Mark" <cmd@mountain.net> wrote in message
> news:%23IxSN3w6DHA.3288@TK2MSFTNGP11.phx.gbl...
> > Hi,
> > At work, on the frontend database, I have a command button which uses
> Winzip
> > to zip the backend database and copy it to a floppy. The user can then
> take
> > this floppy to their home computer and update their home version of the
> > backend database.
> >
> > The problem is that Winzip will not unzip from the floppy and replace
the
> > existing home backend because that file is in use (the database is open
> with
> > its linked tables). The command line is as follows:
> >
> > cmdstring = "C:\Program Files\Winzip\winzip32 -e -o a:\fpsdata.zip
> > C:\Access97\". (The "-e" is to extract; the "-o" is to overwrite).
> >
> > I suspect I wouldn't have any problem if I were using Pkzip, but then I
> > would have to have that installed on all the users' home computers.
> >
> > I'm thinking that a workaround is to unzip the file from the a-drive to
> > another folder and then using the Windows File Copy command to copy and
> > replace the actual backend -- hoping that Windows would let me replace
the
> > (open) backend database even though Winzip wouldn't.
> >
> > Questions:
> >
> > What is the syntax for the Windows File Copy command, and is there a
> better
> > method for automating this process? (I hate having to walk users through
> > this process each time using Windows Explorer!).
> >
> > Thank you.
> > Mark
> >
> >
> >
>
>