Fixing Access annoyances : how to fix the most annoying things about your favorite database / Phil Mitchell and Evan Callahan.

Format:

Book

Author/Creator:

Mitchell, Phil.

Contributor:

Callahan, Evan, 1966-

Language:

English

Subjects (All):

Microsoft Access.

Database management.

Physical Description:

1 online resource (382 p.)

Edition:

First edition.

Place of Publication:

Beijing ; Sebastopol, California : O'Reilly, [2006]

Language Note:

English

System Details:

text file

Summary:

When an application is part of the Microsoft Office suite, it's sure to be a leader in its field. In the realm of desktop database management, Access is top dog with millions of users. But this is one dog that can bite. Although Access is a powerful, relational tool with the fetching talents of a Labrador, it's not an easy beast to train. Still, millions of users count on Access for everything from managing parts databases to running Web catalogs to working as a front end to mondo SQL databases. But Access is chockablock with annoyances---report hassles, query conundrums, VBA bug

Contents:

Contents; Introduction; How to Use This Book; Access Versions; MSKB 123456; Conventions Used in This Book; Using Code Examples; I Did Exactly What You Said, and It Still Doesn't Work!; Safari® Enabled; Acknowledgments; 0: Access Basics; The Database Window; Wizards; Design View and User Views; Setting Properties; Bound Versus Unbound Objects; Multi-User Databases and Split Design; How to Create an Event Procedure; How to Add Code to Your Application; DAO Versus ADO; 1: General Annoyances; Access's Bad Defaults; Global Defaults; Specific Defaults; Alt-Tab Clutter; A Better Alt-Tab

Toolbar/Menu Has Been Moved or Merged into Another OneToolbar Is Disabled at Startup; Missing Objects (Forms, Reports, Queries...); Scroll Wheel Confusion; Turn Off Dire Hyperlink Warnings; Find/Replace for Database Objects; Save Custom Form Placement; Data Entry Without Access; Getting Lost in Datasheet View; Access Is Buggy and Unstable; Flaky or Corrupted Database; Preparation; Use the Built-in Compact/Repair Utility; Export to a New Database; Problem-Specific Suggestions; Professional Help; That Darn Corruption; Network Problems; System Crashes; Access Bugs; Application Bugs; User Error

Missing Wizards or Import/Export/Link OptionsMissing or Broken Wizards; Missing Import/Export/Link Options; Agonies of a Sick Installation; #Name? and #Error?; Misspelled or Nonexistent Name; Missing Equals Sign; Name Is Out of Scope; Incorrect Expression Syntax; Use of Visual Basic Constants; Empty Query or Subform; Parameter Query Embedded in Expression; Wrong Syntax for Subform Reference; Circular References; #Num!, #Div/0!, #Deleted, and #Locked; Enter Parameter Value; No Access License; User-Defined Type Not Defined; Missing References; Disk or Network Errors

Database Is Read-Only or File Is Already in Use

Notes:

"Covers Access 2003, 2002, and 2002"--Cover.

Includes index.

Description based on print version record.

ISBN:

9781491909447

1491909447

9780596153366

0596153368

OCLC:

770009169