Re: Deletions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I developed a backup utility for Access applications after a long sad
tale of woe and lies, more lies and still more lies from the IT
department of a major bank. As you must be aware, regular backup
utilities don't address all of the needs of Access databases. In time
they can become corrupt. This is a function of issues internal to
Access that normal backups don't address. As time has gone on, the
Access team have added a few nifty goodies but they don't go far
enough. You can now set your application to "compact on close". You
can also set it to automatically backup. However, each backup writes
over the only other backup you have created with this process..
Better than nothing but not much gain there! Another huge problem
with those solutions is that a properly implemented Access application
is split. The Front End is all that gets backed up and/or compacted
in a split application. The Back End, with the data, doesn't benefit.
Yet its the Back End that needs it most. The least sophisticated
developers will benefit the most. They're not in multi-user
situations and they wouldn't think of splitting their application. So
it works for them, somewhat.

My utility is called each time the protected application closes. It
operates as another Access application that lists the files to backup
and the root folder for the backups. Beneath that root folder, named
Backups by default, are 7 day-of-the-week files. The Backup root for
the protected application and all of the day files are created by the
application. The Front End and Back End can have different
destinations. For example you could backup the Front End below the
application's folder and backup the Back End on a server.

A text file log is written in the application folder of every event to
do with backing up the files.

Each file is compacted into its day file destination and left
untouched in its original location with a different extension. The
compacted file is then restored back to its original location with its
original name and extension.

In multi-user applications it's unlikely that the first person to quit
the application is also the last. That means that an attempt to gain
exclusive access to the Back End will fail. The utility quietly
finishes the rest of its business and exits. Eventually the last user
will quit the application. When that user's utility tries to gain
exclusive use of the Back End it will succeed. The Back End is
properly backed up, compressed and restored and all is well.

I was within a month or so of having it up on a web site when my
daughter moved another project in front of me. When I get her test
generator done I'll wrap up the backup utility.

HTH
--
-Larry-
--

"Novice2000" <Novice2000@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CE6599C6-1A23-4E18-9D94-D816B3583F28@xxxxxxxxxxxxxxxx

You must have read my mind. We had to do a restore on the database
this
morning. And, though we have automatic backups, there was something
wrong
with the backup from yesterday and we had to use Monday's backup.
Two days of
entries erased.

I decided to backup the database every night before I leave. What
did you
mean "Then do a compact and restore, ready for the next use."


"Larry Daugherty" wrote:

Yes!

It is important to be sure of what you are doing. For extra
confidence, BACKUP your data. How often? How much data can you
afford to lose or to re-enter? I backup automatically every time
I
close the database to a folder below the one with the application
and
a subfolder for the day of the week. Then do a compact and
restore,
ready for the next use.

HTH
--
-Larry-
--

"Novice2000" <Novice2000@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:27BB7151-1FA2-45BA-AD8F-1D4ED4A78071@xxxxxxxxxxxxxxxx
Hi,

Just how sensitive is the data in a table? If while you are
creating a
query you change or delete something in the query will it erase
the
data in
the main table?





.

Relevant Pages

  • New Laptop Dilemma
    ... Purchased a new laptop. ... Had my database copied to a server as backup. ... it back to the new machine and herein lies the problem. ...
    (microsoft.public.access.forms)
  • Re: 9/11/01+3
    ... > Upon the hill that lies, ... You'll take your "backup" against Josh anywhere you can get it, ...
    (sci.space.policy)
  • Re: Proposal of Revision of CDMA newsgroup FAQ by Mike Noel
    ... I have been calling you like a thousand times to backup your lies... ... "Still waiting... ...
    (comp.databases.ms-access)
  • Re: Backing up the computer
    ... Therein, lies the problem!! ... Neither System Restore nor ntBackup makes a ... full backup. ...
    (microsoft.public.windowsxp.basics)
  • Re: Problems with OE Security Update KB923694?
    ... Thanks for the great information Bruce ... ... I do backup daily the OE files using Syncback to an external HD but after ... Now when you compact, ... Many people do not back up Outlook Express on a regular basis. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)