The Importance Of Backing Up

Jun 28, 2007

I'm posting this in the general area as it will eventually save nearly everyone a headache of mass proportions.

Any regular reader of these forums has heard myself and many others talk about the importance of backing up your data on a regular schedule. I've described my method in a little detail, and others have also explained their methods. However, almost without fail, there will be a post in here at least once a week about someone's DB becoming corrupted, lost, deleted, or otherwise FUBARed.

It used to be a pain in the butt to remember to back things up, to track CDs, etc. Lately, however, it's becoming increasingly more affordable to simply buy an external hard drive and schedule it to back up once a day, once every other day, or whatever.

I personally bought a 320GB external drive for $99 at a local giant electronics store, and it backs up my entire 300GB drive once a week at 3:00am every Sunday. Mine takes about 90 minutes to complete, but your mileage may vary depending on the size of your drive, what you decide to backup, etc.

I'm just passing along the information that it has become amazingly cheap to backup everything for very cheap, and you don't even have to think about it. It's just there as a just in case when you need it. There's nothing more frustrating than realizing that everything you've worked on for the past month is suddenly gone, be it to DB corruption, hard drive failure, etc. However, that is completely beat out by the feeling that it's backed up securely.

I don't have any vested interest in this stuff. Rather, there isn't much else for $99 that affords that piece of mind. Keep it in mind the next time you're proud of all the work you've done. It would suck to lose it, wouldn't it? ;)

View Replies


ADVERTISEMENT

Send Email With High Importance Using Access

Jan 12, 2007

Is there any code that will allow me to send an e-mail as "High Priority / High Importance" through Access?

Here is the code I am using currently:

Private Sub Save_Click()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Dim mail
Set mail = Nothing
' Send by connecting to port 25 of the SMTP server.
Dim iMsg
Dim iConf
Dim Flds
Dim strHTML

Const cdoSendUsingPort = 2

'==== A/R 60 Code Start ====
ElseIf Me![A/R Code] = "60" Then

Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")

Set Flds = iConf.Fields
' Set the CDOSYS configuration fields to use port 25 on the SMTP server.
With Flds
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = cdoSendUsingPort
'ToDo: Enter name or IP address of remote SMTP server.
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "usahm204.amer.corp.eds.com"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 10
.Update
End With
' Build HTML for message body.
strHTML = "<HTML>"
strHTML = strHTML & "<HEAD>"
strHTML = strHTML & "<BODY>"
strHTML = strHTML & "This is an automated e-mail to let you know that <b><font color=#FF0000>" & [Name of Requestor] & "</b></font> from <b><font color=#FF0000>" & [Department of Requestor] & "</b></font> has submitted a new <b><font color=#FF0000>A/R " & [A/R Code] & "</b></font> request in PERD."
strHTML = strHTML & "</BODY>"
strHTML = strHTML & "</HTML>"
' Apply the settings to the message.
With iMsg
Set .Configuration = iConf
.To = "<Carol.Patukonis@examhub.exch.eds.com>" 'ToDo: Enter a valid email address.
.Cc = "<Elisa.Chandler@examhub.exch.eds.com>;<Deborah.Davis@examhub.exch.eds.com>"
.Bcc = "<Carlene.Vitello@examhub.exch.eds.com>;<Jason.Boney@examhub.exch.eds.com>"
.From = "PERD Request<Jason.Boney@eds.com>" 'ToDo: Enter a valid email address.
.Subject = "New A/R " & [A/R Code] & " Request"
.HTMLBody = strHTML
.Send
End With
' Clean up variables.
Set iMsg = Nothing
Set iConf = Nothing
Set Flds = Nothing
'==== A/R 60 Code End ====


I have tried using .Priority = "High" and .Importance = "High", but I keep getting an error stating this object property is invalid. What can I use to set a priority (Low, Normal, High) on the e-mail using the above code?

View 11 Replies View Related

Read Only And Backing Up

Oct 24, 2005

Hey, can someone help me out here,
I want to make my database so it is read-only for all other people who use it, besides me, as I'm the only one who really is making changes to it. Would there be a way to do this, perhaps in a multi-user environment?

Also does Access have a tool to automatically backup the database at regular intervals, such as the end of a day. I thought it had that feature but couldn't find it in help.

chris

View 1 Replies View Related

Backing Up A Database

Dec 21, 2004

Is there a way to automatically backup a database? Or is copying the mdb file the only way? Also..has anyone written any VB code that might do this when the database closes?

Any help is much appreciated.

View 1 Replies View Related

Backing Up File

Feb 21, 2006

Is it possible to place a button on a form which will create a backup of the entire file? I add records to a db on a daily basis, and would like to make the process of creating a backup a little easier.

Thanks.

View 11 Replies View Related

General :: Backing Up Db While Db Still In Use

Jun 9, 2015

Will copying the database file while it is still in use, cause corruption in the original file?I've read numerous places that you shouldnt copy the file while it is being opened by another user because you dont know what sort of state the db is in.How to interpret that sentence? Is the consern here that the copy may be corrupt, or that copying the db file corrupts the "active" db file?

I have a script that copies the file each 15 minutes. I also take regular backups manually simply by CTRL+C ->CTRL+V
I then check the "new file", and do a compact and repair. If nothing seems to be wrong, I save it in my backupfolder. Is this actually a problem?

But now, I read that simply copying a db file may cause corruption..Split db, backend about 10mb, 15 concurrent users, all users are writing to the db, all users have their own frontend.All users are on citrix terminal server.

View 4 Replies View Related

Backing Up Entire Database

Sep 12, 2005

Hi :rolleyes:
I would like when I click a button for the system to automatically create a copy of the whole database and place it into a separate folder. How would I do this??? :confused:

Cheers
bikeboardsurf

View 1 Replies View Related

Backing Up/Recombining A Split Database??

Jun 29, 2005

I am wondering if there is a way to recombine a database once it has been split?

More specifically, I am going to split a database on our server so that different individuals can access it at the same time. I am wondering if there is a way to allow for a backup to be done such that if the server crashed, which I am afraid it might, we could recover our database without difficulties.

Is there a way to make a working backup of a split database if you change the directories that the different files are stored in?

Thanks for the help.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved