Fixing Access annoyances how to fix the most annoying things about your favorite database
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 o...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | Inglés |
| Published: |
Beijing ; Sebastopol, California :
O'Reilly
[2006]
|
| Edition: | First edition |
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627207406719 |
Table of 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
