Solved

Access 2007 - What does "Option Compare Database" mean?

Posted on 2010-08-25
3
5,286 Views
Last Modified: 2013-11-28
Experts,

What does "Option Compare Database" mean? Are there other "options" I should know about as a beginner programmer, to insert at the beginning of my code?
0
Comment
Question by:JC_Lives
3 Comments
 
LVL 13

Assisted Solution

by:Surone1
Surone1 earned 250 total points
ID: 33522173
0
 
LVL 77

Accepted Solution

by:
peter57r earned 250 total points
ID: 33522231
Option Compare Database indicates which collation sequence (sort order rules) to be used.
In essence it creates a case-Insensitive operation for text comparisons which is the norm throughout Access.

You can use Option Compare Binary instead which would create case-sensitive text comparisons for operations in that module.

You should use the Tools>Options settings in the VBA window and check the setting which says "Require Variable Declaration".
This will add another statement at the top of each module you subsequently crreate which says
Option Explicit
This option prevents you from using variables which have not been declared explicitly and so is a significant aid in preventing mis-spellings of variables used in code..

0
 

Author Closing Comment

by:JC_Lives
ID: 33522291
Cool people!! Thanks!!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question