Software Venture Consulting
ToMarket

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Brian Dunning
Contact me | vCard


Brian on CNN
Brian on CNN


Brian on CBS Radio


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.


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."

Browse Mode 2006
Aug Top Ten Sessions Cut from the 2006 FileMaker Developer Conference
Jul Who's Driving This Thing, Anyway? Or, How Marketing and Engineering Buried the Hatchet (Warning: Contains a Curse Word)
Browse Mode 2005
Nov Shingle Grandiloquence
Oct In Celebration of Geek Magnetism
Aug A Rogues' Gallery of Devcon Attendees
Mar Lies, Damned Lies, and Project Specifications
Feb Pick the Right Tool for the Job
Browse Mode 2004
Oct Home Media Server Requirements
Jul Leveraging Your FileMaker Lingo
Apr Technical Support Redux
Mar Enforce Seats in FileMaker 7/8/9 Commercial Solutions
Feb Reinventing the Wheel
Browse Mode 2003
Oct WAP: The Technology That Wasn't
Aug Brian Dunning's California Governor Election Platform
Jul Sex and the Single Software Developer
May XSLT: Creeping Out of the Closet?
Feb A Consultant's Guide to Traveling
Browse Mode 2002
Nov Adventures of Bat Magnum, FileMaker Consultant
Sep FileMaker at Area 51
Aug FileMaker Terminology
Feb Computer Shunts
Browse Mode 2001
Dec Aquabase Alpha & the Consultant's Challenge
Aug It IS the Size That Counts
Jun On the Trail of Sasquatch
May Spring Cleaning
Feb FileMaker Mobile Survivor Challenge
Jan Letter from Nürburg
Browse Mode 2000
Dec Performance Anxiety
Nov Objection, Your Honor
Oct FileMaker's Role in the New Economy
Sep Top Ten Things to Do at Devcon
Aug Aesop's FileMaker Fables
Jul Ten Commandments of FileMaker Pro
Jun Explats Cross Examined
May iMac, Therefore iServe
Mar Valley of the Dollars
Jan Are You Up for a Review?
Browse Mode 1999
Nov Tales from the Script
Sep Tech Support Revisited
Jul Moderns vs. Classicals
Mar Nashoba, We Hardly Knew Ye