Hi Friends,

My Application is connected to MS Access database. I want to provide one
option as Backup and another option for Restore. I use Delphi 5 with ADO to
connect DB.

What is the best way to Backup the Dabase and Restore it?

I think as this is a Filebased DB, We should Make a Copy of the Database
file (.mdb) and Compact the new copied file.

Please suggest any idea. If i can get some Code fragment it will be helpful
for me.

Thanks
Prabhat
http://prabhatnath.blogspot.com

Copying the file is the best way to back it up. Make sure you do it when no
one is using the file. I've never corrupted a file by copying it when it is
open, but it is possible to do so. For compacting, you may want to look at
some of these KB articles:

http://support.microsoft.com/search/...de=s&cat=False

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Prabhat" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Friends,
>
> My Application is connected to MS Access database. I want to provide one
> option as Backup and another option for Restore. I use Delphi 5 with ADO
> to
> connect DB.
>
> What is the best way to Backup the Dabase and Restore it?
>
> I think as this is a Filebased DB, We should Make a Copy of the Database
> file (.mdb) and Compact the new copied file.
>
> Please suggest any idea. If i can get some Code fragment it will be
> helpful
> for me.
>
> Thanks
> Prabhat
> http://prabhatnath.blogspot.com
>
>

Thanks Arvin for the reply. I will copy the DB for backup. And inmy case the
DB will be local to the PC and only user will be connected.

Thanks
Prabhat
http://prabhatnath.blogspot.com

"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Copying the file is the best way to back it up. Make sure you do it when
no
> one is using the file. I've never corrupted a file by copying it when it
is
> open, but it is possible to do so. For compacting, you may want to look at
> some of these KB articles:
>
>
http://support.microsoft.com/search/...3D1033&spid=gl
obal&query=Compact+a+JET+database+from+VB&adv=&mode=s&cat=False
>
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> "Prabhat" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi Friends,
> >
> > My Application is connected to MS Access database. I want to provide one
> > option as Backup and another option for Restore. I use Delphi 5 with ADO
> > to
> > connect DB.
> >
> > What is the best way to Backup the Dabase and Restore it?
> >
> > I think as this is a Filebased DB, We should Make a Copy of the Database
> > file (.mdb) and Compact the new copied file.
> >
> > Please suggest any idea. If i can get some Code fragment it will be
> > helpful
> > for me.
> >
> > Thanks
> > Prabhat
> > http://prabhatnath.blogspot.com
> >
> >
>
>

"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> Copying the file is the best way to back it up.

I am informed in another forum that Access 2003 has a BACKUP option
on the database utilities menu. Is this true? And, of so, how does
it work?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

You were informed correctly. I never noticed it before, but it's there. It
just makes a physical copy of the .mdb file, defaulting to adding the date
to the file name, like "_2007-05-23". The backed up copy is an mdb file.

From the help file:
Back up an Access database

1.. Save and close all objects in the database.
2.. On the File menu, click Back Up Database.
3.. In the Save Backup As dialog box, specify the name and location of the
backup copy.

"David W. Fenton" <(E-Mail Removed)> wrote in message
news:Xns99398BF1EA7B5f99a49ed1d0c49c5bbb2@127.0.0.1...
> "Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in
> news:(E-Mail Removed):
>
>> Copying the file is the best way to back it up.
>
> I am informed in another forum that Access 2003 has a BACKUP option
> on the database utilities menu. Is this true? And, of so, how does
> it work?
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/

it is impossible to reliably backup an access MDB database

you shoudl move to SQL Server; this has the 'maintenance plan wizard' built
into the product


"Prabhat" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Friends,
>
> My Application is connected to MS Access database. I want to provide one
> option as Backup and another option for Restore. I use Delphi 5 with ADO
> to
> connect DB.
>
> What is the best way to Backup the Dabase and Restore it?
>
> I think as this is a Filebased DB, We should Make a Copy of the Database
> file (.mdb) and Compact the new copied file.
>
> Please suggest any idea. If i can get some Code fragment it will be
> helpful
> for me.
>
> Thanks
> Prabhat
> http://prabhatnath.blogspot.com
>
>

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"Tom Wickerath MDB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> it is impossible to reliably backup an access MDB database
>
> you shoudl move to SQL Server; this has the 'maintenance plan wizard'
> built into the product
>
>
> "Prabhat" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi Friends,
>>
>> My Application is connected to MS Access database. I want to provide one
>> option as Backup and another option for Restore. I use Delphi 5 with ADO
>> to
>> connect DB.
>>
>> What is the best way to Backup the Dabase and Restore it?
>>
>> I think as this is a Filebased DB, We should Make a Copy of the Database
>> file (.mdb) and Compact the new copied file.
>>
>> Please suggest any idea. If i can get some Code fragment it will be
>> helpful
>> for me.
>>
>> Thanks
>> Prabhat
>> http://prabhatnath.blogspot.com
>>
>>
>

"Paul Shapiro" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> You were informed correctly. I never noticed it before, but it's
> there. It just makes a physical copy of the .mdb file, defaulting
> to adding the date to the file name, like "_2007-05-23". The
> backed up copy is an mdb file.
>
> From the help file:
> Back up an Access database
>
> 1.. Save and close all objects in the database.
> 2.. On the File menu, click Back Up Database.
> 3.. In the Save Backup As dialog box, specify the name and
> location of the
> backup copy.

If you can tell, does it use a file copy (i.e., closes the database
and copies it) or does it compact to the new filename or use some
other Jet command to create the backup?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

> If you can tell, does it use a file copy (i.e., closes the database
> and copies it) or does it compact to the new filename or use some
> other Jet command to create the backup?
>
> --
Hi,

I have tested the Backup procedure in MS Access. It is using the Jet Command
(JRO) to Compact the Database and Copy it with the "Date" added to the DB
file name.

Thanks
Prabhat
http://prabhatnath.blogspot.com