I don't want an answer. I want to get a fix to the problem.

#sqlite3 skywalker.rmgc 

sqlite> .tables
AddressLinkTable     FamilyTable          PlaceTable         
AddressTable         GroupTable           ResearchTable      
ChildTable           LabelTable           RoleTable          
CitationTable        LinkTable            SourceTable        
ConfigTable          MediaLinkTable       SourceTemplateTable
EventTable           MultimediaTable      WitnessTable       
ExclusionTable       NameTable          
FactTypeTable        PersonTable        

sqlite> .schema NameTable
CREATE TABLE NameTable (NameID INTEGER PRIMARY KEY, OwnerID INTEGER, 
Surname TEXT COLLATE RMNOCASE, Given TEXT COLLATE RMNOCASE, Prefix TEXT 
COLLATE RMNOCASE, Suffix TEXT COLLATE RMNOCASE, Nickname TEXT COLLATE 
RMNOCAS E, NameType INTEGER, Date TEXT, SortDate INTEGER, IsPrimary 
INTEGER, IsPrivate INTEGER, Proof INTEGER, EditDa te FLOAT, Sentence 
BLOB, Note BLOB, BirthYear INTEGER, DeathYear INTEGER );
CREATE INDEX idxGiven ON NameTable (Given);
CREATE INDEX idxNameOwnerID ON NameTable (OwnerID);
CREATE INDEX idxNamePrimary ON NameTable (IsPrimary);
CREATE INDEX idxSurname ON NameTable (Surname);
CREATE INDEX idxSurnameGiven ON NameTable (Surname, Given, BirthYear, DeathYear);
.exit

Mather said Silver Tail scanned the former employee's system with three different anti-virus tools, yet none of them detected any suspicious or hostile files. Company technicians only located the malware by conducting a manual search for telltale files most commonly associated with different Zeus variants.

       cacls "\Program Files\Generations" /E /G USERS:C

CREATE OR REPLACE FUNCTION no_empty_tables() RETURNS "trigger" AS $_$
DECLARE
 rowcount integer;
BEGIN
  SELECT count(*) INTO rowcount FROM test_table;
  IF rowcount = 1 THEN
    raise exception 'Cannot allow empty table';
  END IF;
  RETURN OLD;
END;
$_$ LANGUAGE plpgsql;

CREATE TRIGGER dont_allow_empty_table BEFORE DELETE ON
test_table FOR EACH ROW EXECURE PROCEDURE no_empty_tables();

    <Files mt-config.cgi>
       deny from all
    </Files>

create table small_test ( name varchar(10), is_default boolean default false );

alter table small_test add constraint allow_only_one_default check (count_default_rows() < 2);

create or replace function test_only_one_default() returns trigger as $_$
declare
  rowcount integer;
begin
  if new.is_default then
    select count(*) into rowcount from small_test where is_default;
    if rowcount > 0 then
      raise exception 'Second default setting is not possible';
    end if;
  end if;
  return new;
end;
$_$ language plpgsql;

create trigger allow_only_one_default before insert or update on
  small_test for each row execute procedure test_only_one_default();

Essentially:
mdadm --examine --scan /dev/hda1 |
sed 's/ devices=.dev.[a-z09-]*/&,missing/' |
cat >> /etc/mdadm/mdadm.conf
/etc/init.d/mdadm start
/etc/init.d/mdadm-raid start

• gedit, comes with the GNOME desktop,
• Kate, comes with the KDE desktop but may be buildable within GNOME,
• Bluefish, for both GNOME and KDE. Included with OpenSuSE,
• Scribes, for GNOME looks nice,
• SciTE, built on the SCIntilla toolkit.

• NotePad++, fast and usable, also built on SCIntilla but with a nice style,
• SciTE even works on NT4.0.

Hard disks in external drives are still just electro-mechanical devices which will eventually fail. Similarily, flash drives can be corrupted by static charges and mechanical wear and tear (i.e. insertion torque, sitting on them, etc.), failing to "safely remove hardware". And on; not forgetting theft, fire, hurricanes, etc. depending on the importance of the data and how much you want to spend.

Any primary storage needs some backup. So if you rely on an external USB drive as a primary storage ... then I guess you need a second one to make backups.

Copying to DVD periodically is a good idea.

Other options include on-line backup. Amazon S3 is a good storage product. It's is not free, but there are lots of tools:

• Firefox plugins
• JetS3t
• JungleDisk
• s3sync in Ruby
• etc.

mozy offers 2 Gb for free for home use. Some others are box.net, Carbonite, elephantdrive, rsync.net, E-Vault, etc. But on-line backup providers can go out of business making your backups disappear. OmniDrive has gone away and XDrive is kind enough to say so in advance of Jan.12/2009.

Regarding the MS-Access/Jet database file format, we can say that: it is not reliable, it is not scalable, it is not multi-user, it is not portable, and it is not free. Searching the Internet will help to find some evidence to back-up those claims.

Google for "access database corruption" Results 1 - 10 of about 364,000
Google for "access database limitations" Results 1 - 10 of about 634,000

An older document ( http://support.microsoft.com/kb/168549/ ) regarding Access97, but still available from Microsoft contains:

FAQ section summary:
Jet at best can handle 50 users and 100 mb of data.
Jet's limit is 1.2 Gb of data.
Jet can't be back'ed up while in use.

A newer Microsoft document ( http://msdn2.microsoft.com/en-us/library/ms811092.aspx#msdeforvs_topic8 ) lists limits from real life use:

"Jet can support up to 255 concurrent users, but performance of the file-based architecture can prevent its use for many concurrent users. In general, it is best to use Jet for 10 or fewer concurrent users."

This Microsoft document ( http://support.microsoft.com/default.aspx/kb/222135 ) updated on January 24, 2007 warns against its use:

"While Microsoft Jet is consciously (and continually) updated with many quality, functional, and performance improvements, it was not intended (or architected) for the high-stress performance required by 24x7 scenarios, ACID transactions, or unlimited users, that is, scenarios where there has to be absolute data integrity or very high concurrency."

And http://support.microsoft.com/kb/q303528/ updated on January 9, 2007 contains several red flags about corruption and performance:

"An efficiently designed database also helps reduce the risk of file corruption."

"Microsoft Jet is not intended for use with high-stress server applications, high-concurrency server applications, or 24 hours a day, seven days a week server applications. This includes server applications, such as Web applications, commerce applications, transactional applications, and messaging server applications. For these types of applications, the best solution is to switch to a true client/server-based database system, such as Microsoft Data Engine (MSDE) or Microsoft SQL Server. When you use Microsoft Jet in high-stress applications such as Microsoft Internet Information Server (IIS), you may experience any one of the following problems:
- Database corruption
- Stability issues, such as IIS crashing or locking up
- Sudden failure or persistent failure of the driver to connect to a valid database that requires re-starting the IIS service.

Anyone remember the huge chess matches in the late 70s / early 80s where Prof. Dik van Kleef would take on dozens of players all at one time in Bloomfield Centre.

Prof. van Kleef (passed away a few years ago) was a visiting researcher from the Zeeman Lab in Amsterdam (split spectral lines of sodium and all that). He often spent summers in Antigonish collaborating with Dr. Y. Joshi. They published skads of papers together.
  I got to know him during the years I spend working in Dr. Joshi's lab.

I played once or twice in those simultaneous chess games. He was at the Master level, I forget his ranking, I could never win.

But I remember that I was there when someone did beat the Master, perhaps it was in the very last of those simultaneous games.
  I think the guy was a high school student at the time, and I'm also pretty sure that he went on to become an X Physics grad.
  Does anyone remember who that was ? Was it Cliff Liem, was it Allan Brent, one of the Pham brothers maybe ?

How many out there remember the refrain of the late Fr. F. Ginnivan of the Math Dept. "Read the book, it's in the book".

I never had him as a prof, but he was the chair of the dept in my grad year. Stories from long ago seem to have the same ring as recent ones; he was a pretty tough nut.

I'm not sure that I saw him smile while on campus; until the day he retired. I kid you not. Those of you who did suffer though his classes may find it hard to believe but on the day he retired he became one of the easiest going, most friendly persons you could meet.
  I was working on campus during that time. I'm pretty sure that he smiled from that day till the day he died.

He took up an interest in computers, took some classes and where would you find him most evenings, why it was in the computer labs, cheerfully helping students with their assignments.

During the winter he tried to spend time on the slopes. I remember one time when he was more than happy to share a funny story about how the slopes were so icy that he had to slide down all the way from the top on his bum and wore a hole in his pants.

Sometimes I miss Fr. Ginn.
I hope that my kids will get to know a teacher like him.

I'm interested in hearing some personal stories about the late Fr. E. Clarke of the Physics Dept.

I remember meeting him once or twice in the late 1970's, probably in the Science Library and in the then Electronics Shop.
  He was retired then, elderly but with an air of importance. I recall that others who knew him showed great respect.

I think that someone once told me that he designed the transmission facilities for CJFX Radio.
  Years later, Regis Kell told me a story of one day when CJFX was off the air. Someone called Fr. Clarke to see if he could troubleshoot the problem. He went up to the transmission tower on the highway, took a piece of wood and gave it a few bangs with a hammer to wedge it under one of the legs of the tower. Problem solved.

More years later Prof. T. Weingartshofer (I apologize for any misspelling) told me of how Fr. Clarke's research was a vital part of the international effort towards the understanding of the electron.