And Inserting It into Power Point Using the Access Object Model to Pull Data from Access

to Other Applications 467

Summary 470

Chapter 16: Database Security_471

Access Security Model Overview 471

Shared-Level Security 474

Shared-Level Secured Back-End Databases 474

Setting Up Shared-Level Security Using the Access Interface 475

Encoding a Database 480

Creating an Encoded Database 481

Decoding an Encoded Database 481

Secure VBA Code 481

Securing Modules by Securing the Project 481

Compiling to Make an MDE File 484

User-Level Security 487

Main Components of User-Level Security 488

Methods to Create User-Level Security 492

Summary 529

Chapter 17: Understanding Client/Server Development with VBA_531

ADP Versus MDB: Choosing the Right Client Format 532

What Is an MDB File? 532

What Is an ADP? 543

Which Format Is Right for You? 550

Controlling the Logon Process 552

Using Linked Tables with MDB Files 552

Using Access Projects 555

Binding Recordsets to Objects 558

Binding to a Form, Combo Box, or List Box 558

Binding to a Report 558

Using Persisted Recordsets 562

Using Unbound Forms 564

Why Use Unbound Forms? 564

Summary 572

Chapter 18: Working with the Win32 Registry_573

About the Registry 574

What the Registry Does 574

What the Registry Controls 575

Accessing the Registry 576

Registry Organization 576

Using the Built-In VBA Registry Functions 581

SaveSetting 582

GetSetting 583

GetAllSettings 583

DeleteSetting 584

Typical Uses for the Built-In VBA Registry Functions 585

Using the Win32 Registry APIs 588

Putting It All together 588

Summary 598

Chapter 19: Using the ADE Tools_599

Redistributable Access Runtime 600

Property Scanner 601

Property Scanner Search Specification 601

Search Results 603

Custom Startup Wizard 603

Step 1: Identify the Template 605

Step 2: Describe the Database and Set Startup Options 605

Step 3: Define the Startup Options in the Database 607

Step 4: Save the Template/Create a Batch File 609

Package Wizard 610

Step 1: Identify the Template 610

Step 2: Define the Package to Create 611

Step 3: Define the Application Startup Options 613

Step 4: Add Files and Registry Keys 615

Step 5: The Installer's Experience 615

Step 6: Set Installer Package Properties 618

Step 7: Save the Template/Create a Batch File 619

Step 8: (Optional) Modify Your Install Package (MSI) 620

Summary 624

Chapter 20: Macro Security_627

Macro Security 628

What Is Macro Security? 628

Why Have Macro Security? 628

Security Checks Done before Opening a Database 629

Digital Signatures and Certificates 634

Types of Digital Signatures 635

Using Self-Certification 636

Microsoft Jet Expression Services and Sandboxes 643

More about Errors and How to Fix Them 644

Sandbox Mode Limitations 646

Workarounds 646

Summary 647

Apendix A: Upgrading to Access 2003 651

Apendix B: References for Projects 667

Apendix C: DAO Object Method and Property Descriptions 679

Apendix D: ADO Object Model Reference 715

Apendix E: The Access Object Model 731

Apendix F: Windows API Reference Information 803

Apendix G: Naming Conventions 809

Apendix H: Reserved Words and Special Characters 833

Apendix I: Tips and Tricks 847

Apendix J: ADO Object Argument Information 887

Apendix K: Access Wizards, Builders, and Managers 903

Apendix L: Windows Registry Information 909

Index 933

0 0

Post a comment