Re: Replacing backend database

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Adrian Jansen (qqv_at_noqqwhere.com)
Date: 02/04/04 

Date: Thu, 5 Feb 2004 09:36:50 +1000

VBA code

Filecopy sourcefile destinationfile

will copy a file from one location to another. But you are missing the
point. Its very dangerous to copy an open database. 

--
Regards,
Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
"FPS, Romney" <fpswv@citlink.net> wrote in message
news:#deFKx06DHA.2056@TK2MSFTNGP10.phx.gbl...
> 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
> > >
> > >
> > >
> >
> >
>
>
Quantcast