Backup

  • Thread starter Thread starter Srinivas
  • Start date Start date
S

Srinivas

Sir,

I have created a database in msaccess 2003, in form i want to create a
button and after clicking button backup should done automatically or a window
should open showing place of location it is saving and file name with backup
date)
 
On Wed, 31 Mar 2010 03:34:01 -0700, Srinivas

That is not easy, because a file should not be backed up while it is
in use. Typically we backup files at night, while nobody is in the
database, using a backup program or script that runs automatically.
You do need to split your database in front-end and back-end.

-Tom.
Microsoft Access MVP
 
Sir,

I have created a database in msaccess 2003, in form i want to create a
button and after clicking button backup should done automatically or a window
should open showing place of location it is saving and file name with backup
date)
Click to expand...

I put following line is a batch file 'backup,bat' and put in windows
scheduler to run nighly. each backup file has a date at the end of
file name and 7za makes it very small. 7za is a free utility. google
to get it.

7za.exe a s:\archive\backenddata%DATE:~-8,4%%DATE:~0,2%%DATE:~3,2%.7z
s:\apps\backenddata.accdb
 
Srinivas said:
Sir,

I have created a database in msaccess 2003, in form i want to create a
button and after clicking button backup should done automatically or a
window
should open showing place of location it is saving and file name with
backup
date)
Click to expand...
 
Srinivas said:
Sir,

I have created a database in msaccess 2003, in form i want to create a
button and after clicking button backup should done automatically or a window
should open showing place of location it is saving and file name with backup
date)
Click to expand...

When the user exits the FE attempt to rename the backend MDB
preferably with todays date in the name in yyyy-mm-dd format. Ensure
you close all bound forms, including hidden forms, and reports before
doing this. If you get an error message, oops, its busy so don't
bother. If it is successful then compact it back.

See my Backup, do you trust the users or sysadmins? tips page for more
info.
http://www.granite.ab.ca/access/backup.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
بسم الله الرحمن الرحيم
مرحبا بك ÙÙŠ منتديات دريم بريده

علي الموقع http://www.dreambr.com/vb/

برامج جديد علي موقع
 
بسم الله الرحمن الرحيم
مرحبا بك ÙÙŠ منتديات دريم بريده

علي الموقع http://www.dreambr.com/vb/

برامج جديد علي موقع

الان عرض الدريم بوكس 200 ريال + اشتراك 6 + الشحن ÙÙŠ اي منطقه ÙÙŠ السعوديه
ووو
سبايدر - Spider 200 ريال + اشتراك 6 + الشحن
 
Back
Top