Power Outage - Recovery Advice

[David Portwood]

I have a split application (FE/BE) distributed to about 50 users which was
probably running for most of them when the power suddenly went out this
afternoon. We were all sent home.

When I return in the morning I know to check tables for unmatched/orphaned
records and so forth. But what kinds of system things should I be thinking
about? For instance, will I have to delete .lck (lock) files to get back
into the app?

I'm expected to be expert on this stuff (of course, like most experts I'm
learning as I go and "winging it" the rest of the time) so I'd like to have
an idea of what to expect and what I might have to correct when I go in
tomorrow morning. Any advice would be appreciated.

 

[John W. Vinson]

I have a split application (FE/BE) distributed to about 50 users which was
probably running for most of them when the power suddenly went out this
afternoon. We were all sent home.

When I return in the morning I know to check tables for unmatched/orphaned
records and so forth. But what kinds of system things should I be thinking
about? For instance, will I have to delete .lck (lock) files to get back
into the app?

I'm expected to be expert on this stuff (of course, like most experts I'm
learning as I go and "winging it" the rest of the time) so I'd like to have
an idea of what to expect and what I might have to correct when I go in
tomorrow morning. Any advice would be appreciated.

The lock files have .ldb extensions, and unless you get an error that a table
is locked by another user, it's probably not necessary to delete them. Won't
hurt to do so though. I'd worry more about *corrupted* records, particularly
memo fields; if anyone was editing a record at the moment the lights went out,
you could have a damaged record. Check Tony's website for symptoms and
solutions:

http://www.granite.ab.ca/access/corruptmdbs.htm

John W. Vinson [MVP]

 

[Tom van Stiphout]

On Wed, 17 Oct 2007 16:55:49 -0700, "David Portwood"

I would delete the LDB files, and compact the BE. If users have
problems with their FE, I would give them a new one.

-Tom.

 

[Tony Toews [MVP]]

I'd worry more about *corrupted* records, particularly
memo fields;

Agreed. I'd get everyone to check that the last few things they did
look fine.

if anyone was editing a record at the moment the lights went out,
you could have a damaged record.

Not quite in my opinion. I'd be more concerned about if it was in
that moment of time when they go to a new record or close a form. IOW
when updating the record. I don't think being in the middle of
editing a record, where the pencil is present in the status bar of the
left hand side, is a problem. Yes, a record is locked but that
should be about it.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/