
November 1999
Tales from the Script
by Brian Dunning
digg this
article | del.icio.us
this article
It
was a dark and stormy night...
Sheets of hard rain drummed the roof of his car as he squinted
through the streaked windshield. The thick planks of the bridge
cracked with age as his heavy wheels rolled slowly over the torrents
below. A shock of white, as lightning snapped a photograph of
the crumbling stone towers. He slammed the door and ran through
the crazed maelstrom of water and shrieking wind. His shoes skidded
on the wet cobblestones.
Rivers of rushing water cascaded down from the dizzying stone
heights above. He raised the heavy iron knocker and let it fall
once, twice, thrice. His suit jacket flapped in the wind as he
stood waiting. A metallic thud from deep inside the heavy castle
foundation, and the cacophony of chain rattling through cogs and
machinery. The oaken gate shuddered as it rose. The tall gaunt
figure, draped in a musty tuxedo, regarded him through dark eyes
set deep in his pale gray face.
"You must be the FileMaker consultant," he said at last. "Please
come in."
The Consultant stumbled forward and tipped the water out of his
PowerBook case.
"I understand you're having some problems with your files."
"This way, sir." The tall man held aside some cobwebs and led
the way down a murky spiral staircase, hewn from the living rock
of Crag Horn. Startled by the torch, a furry spider scrambled
into a dark crack.
"Ah, you're here at last," said the Professor, flipping the magnifying
lens up from his glasses. "We've had a dastard of a problem with
our database."
A villager, bound to the table with thick leather straps, groaned
in agreement.
"See here," said the Professor, and worked the mouse. "Connection
to the host has been lost."
"No problem," said the Consultant. "Where's your server?"
The Professor stared blankly. He turned to his buxom Assistant,
who shrugged.
"The server," repeated the Consultant. "The computer where your
files are being hosted from."
"Ya ya, is over here," said the Assistant, and her yellow pigtails
swung as she turned to a workstation on her tidy desk. "Zis is
hosting ze Procedures file and ze Patients file. Ze Instruments
and Experiments files are on ze Professor's laptop. Except for
his backups, which I keep here," and she clicked open a folder
on her desktop.
The Consultant scratched his head and opened his mouth to speak,
but the Professor interrupted: "And this file is losing records.
I'll spend half a day inputting data, and the next morning they're
all gone."
"Ya," said the assistant, "and whenever ze Professor does a Replace,
I get ze coffee cup."
"You get the Professor's coffee?"
"No, I get ze coffee cup icon, and I have to force quit."
"While you're hosting other files?"
"Ya."
"And that's when the Professor's connection is lost."
The Professor and the Assistant exchanged a confused look.
"We think we need to switch to Access," said the Professor at
last. "Can you help us do that?" The villager nodded his assent
vigorously, as much as the restraints would let him.
"Hold it! You mustn't do that. You're already invested in FileMaker.
Your report layouts are in FileMaker. All your data is in FileMaker,
and
" he clicked open Define Fields
"look at all these
calculation and summary fields. Access can't accommodate those.
You'd lose almost everything you've done."
"But young man, we're having so many problems. FileMaker is a
terrible database!"
"There's nothing wrong with FileMaker. What's wrong is the way
you've configured your machines."
They gathered behind him as he sat down in the Assistant's orthopedic
chair and launched FileMaker.
"See here. When you have backup copies of files on the same network,
with the same name as the originals, there's no telling which
copy FileMaker might open. That's why, Professor, some of your
records appear to vanish. It's because you entered them into a
different copy of the file.
"And look at this. This machine is hosting some of the files,
and that machine is hosting others. If either machine crashes,
or someone force-quits, both users are going to have corruption
or a dropped connection."
"What should we do?"
"Install FileMaker Server! Put it on a dedicated machine, and
don't let anyone touch it."
The Professor staggered back, clutching at his breast. "I can't
afford that! A dedicated computer, and FileMaker Server! The cost!
I'd have to excise dozens of
"
The villager scratched at his hollow cranium.
The Consultant silenced the Professor with an outstretched palm.
"The cost? What is your time worth? What does it cost you every
time you have re-input data? What does it cost you every time
you rebuild corrupted files and reconstruct lost layouts? I say,
you can't afford NOT to use FileMaker Server."
"It handles the backups automatically and unattended, so there
will be no more multiple, unsynchronized copies on the network.
When you crash your computer, or force-quit FileMaker for any
reason, the files are unaffected. Your performance will improve
dramatically, and you can say goodbye permanently to all the problems
you've had!"
"Sold!" said the Professor and his Assistant in the same breath.
The Consultant felt the tall man's sturdy hands close around his
arms from behind.
"Now be a good lad," said the Professor, "and climb up on the
table."
|