Differential Backup

[Prabhat]

Hi Friends,

Is it possible that we can have Differential Backup in MS Access ver. 2000
or above? If yes how?

Or Can we write a program in VB / Delphi that will do that work for me?

Thanks
Prabhat

 

[John Vinson]

Hi Friends,

Is it possible that we can have Differential Backup in MS Access ver. 2000
or above? If yes how?

Or Can we write a program in VB / Delphi that will do that work for me?

Thanks
Prabhat

What do you want to back up? Access Table data? The Access application
itself? Your hard disk (using Access to track what's backed up where)?

Details please!

John W. Vinson[MVP]

 

[Prabhat]

Hi,

Mainly I need to track the table data updates. Also onece in a week entire
Access DB.

Please let me know any other details you need.

Prabhat

 

[Prabhat]

Hi,

Mainly I need to track the table data updates. Also onece in a week entire
Access DB.

Please let me know any other details you need.

Prabhat

 

[John Vinson]

Hi,

Mainly I need to track the table data updates. Also onece in a week entire
Access DB.

Could you explain what you mean by "track the table data updates"? Are
you looking for an audit trail, indicating who updated which record
and when? Or a true field-for-field backup?

There are some good audit trail samples out on the web; one you might
want to look at is http://allenbrowne.com/AppAudit.html.


John W. Vinson[MVP]

 

[John Vinson]

Hi,

Mainly I need to track the table data updates. Also onece in a week entire
Access DB.

Could you explain what you mean by "track the table data updates"? Are
you looking for an audit trail, indicating who updated which record
and when? Or a true field-for-field backup?

There are some good audit trail samples out on the web; one you might
want to look at is http://allenbrowne.com/AppAudit.html.


John W. Vinson[MVP]

 

[Prabhat]

Hi John,
Thanks for reply. Actually I wanted to know how many ways are there to
Backup a MS Access DB? As far I know the backup mean we have to keep a DB
copy in a regular interval of time: say Once daily at mid night. So here we
are backing up the entire DB as a whole file, So can we make a differential
backup like MS SQl Server or Oracle?

Thanks
Prabhat

 

[Prabhat]

Hi John,
Thanks for reply. Actually I wanted to know how many ways are there to
Backup a MS Access DB? As far I know the backup mean we have to keep a DB
copy in a regular interval of time: say Once daily at mid night. So here we
are backing up the entire DB as a whole file, So can we make a differential
backup like MS SQl Server or Oracle?

Thanks
Prabhat

 

[John Vinson]

Hi John,
Thanks for reply. Actually I wanted to know how many ways are there to
Backup a MS Access DB? As far I know the backup mean we have to keep a DB
copy in a regular interval of time: say Once daily at mid night. So here we
are backing up the entire DB as a whole file, So can we make a differential
backup like MS SQl Server or Oracle?

There are no built-in tools to do so. You can, of course, create your
own by linking to a separate backend .mdb file and running Append
queries - but this would be complex and hard to manage!

Have you considered using MSDE or SQL/Server Express - or for that
matter SQL/Server, if you have it available - as the table repository,
instead of using .mdb files? This can give you the best of both: the
hot backups, transactions, etc. of SQL with the ease of development of
an Access frontend.

John W. Vinson[MVP]

 

[John Vinson]

Hi John,
Thanks for reply. Actually I wanted to know how many ways are there to
Backup a MS Access DB? As far I know the backup mean we have to keep a DB
copy in a regular interval of time: say Once daily at mid night. So here we
are backing up the entire DB as a whole file, So can we make a differential
backup like MS SQl Server or Oracle?

There are no built-in tools to do so. You can, of course, create your
own by linking to a separate backend .mdb file and running Append
queries - but this would be complex and hard to manage!

Have you considered using MSDE or SQL/Server Express - or for that
matter SQL/Server, if you have it available - as the table repository,
instead of using .mdb files? This can give you the best of both: the
hot backups, transactions, etc. of SQL with the ease of development of
an Access frontend.

John W. Vinson[MVP]