If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Backup
How do I back up my database with Access 2000. I do not
have the Tools, Database Utilities, Back up. (Back up is not in the available features). I want to ensure that my data will not be lost. I have transfered my data in SQL format and saved that part. But I want the database to update the data daily. Any ideas? Michelle |
#2
|
|||
|
|||
Backing up an Access database should be part of your normal network backup
operations. It should be handled just like any other file on your computer or network. There is no backup feature in Access. Remember, Access isn't like SQL Server or Oracle - it's not a server based database. It is file based. If you are just trying to make a quite easy backup, simply make a copy of the mdb file using windows explorer. Shaun Beane, MCDBA, MCT dbageek.blogspot.com "Michelle" wrote in message ... How do I back up my database with Access 2000. I do not have the Tools, Database Utilities, Back up. (Back up is not in the available features). I want to ensure that my data will not be lost. I have transfered my data in SQL format and saved that part. But I want the database to update the data daily. Any ideas? Michelle |
#3
|
|||
|
|||
Well, there is a backup feature in Access 2003. (File, Backup database ...).
But I do agree that backup is a job best left to specialized backup software. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Shaun Beane" wrote in message ... Backing up an Access database should be part of your normal network backup operations. It should be handled just like any other file on your computer or network. There is no backup feature in Access. Remember, Access isn't like SQL Server or Oracle - it's not a server based database. It is file based. If you are just trying to make a quite easy backup, simply make a copy of the mdb file using windows explorer. Shaun Beane, MCDBA, MCT dbageek.blogspot.com "Michelle" wrote in message ... How do I back up my database with Access 2000. I do not have the Tools, Database Utilities, Back up. (Back up is not in the available features). I want to ensure that my data will not be lost. I have transfered my data in SQL format and saved that part. But I want the database to update the data daily. Any ideas? Michelle |
#4
|
|||
|
|||
yeah, sorry, should have specified there is no backup option in Access
2000 - the version Michelle was asking about. -- Shaun Beane, MCDBA, MCT http://dbageek.blogspot.com "Brendan Reynolds" brenreyn at indigo dot ie wrote in message ... Well, there is a backup feature in Access 2003. (File, Backup database ...). But I do agree that backup is a job best left to specialized backup software. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Shaun Beane" wrote in message ... Backing up an Access database should be part of your normal network backup operations. It should be handled just like any other file on your computer or network. There is no backup feature in Access. Remember, Access isn't like SQL Server or Oracle - it's not a server based database. It is file based. If you are just trying to make a quite easy backup, simply make a copy of the mdb file using windows explorer. Shaun Beane, MCDBA, MCT dbageek.blogspot.com "Michelle" wrote in message ... How do I back up my database with Access 2000. I do not have the Tools, Database Utilities, Back up. (Back up is not in the available features). I want to ensure that my data will not be lost. I have transfered my data in SQL format and saved that part. But I want the database to update the data daily. Any ideas? Michelle |
#5
|
|||
|
|||
Hi Michelle,
Like Brendan says it would be easier to use a specialized software to do that. I recommend you to try Backup4all, http://www.backup4all.com , it will allow you to schedule a backup job for your database and after a full backup you can let it do daily incremental backups(it will only add the things that changed) and you would spare some time and, in case the database is large, some space. I would also recommend you to do the backup on an external hard drive or a CD/DVD, not on the same hard drive. -- Regards, Claudiu Spulber http://www.backup4all.com// "Michelle" wrote in message ... How do I back up my database with Access 2000. I do not have the Tools, Database Utilities, Back up. (Back up is not in the available features). I want to ensure that my data will not be lost. I have transfered my data in SQL format and saved that part. But I want the database to update the data daily. Any ideas? Michelle |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
URGENT: Mailing rule problems of filing in outlook express and hard copy file systems in real case | Teres | Outlook Express | 7 | August 14th, 2004 01:55 AM |
Export messages | Gio & Patty | Outlook Express | 1 | July 14th, 2004 09:46 PM |
OE Freebie Backup -- help needed | John Blaustein | Outlook Express | 5 | July 4th, 2004 03:53 AM |
PST Backup Tool Office 2003 Broken? | boyron | General Discussion | 2 | June 11th, 2004 06:57 PM |
Unique Backup Filename, Not | AA | General Discussion | 15 | May 31st, 2004 04:31 PM |