Advertisement

10.20.2007 at 10:32PM PDT, ID: 22907167
[x]
Attachment Details

OPTION COMPARE DATABASE

Asked by cations in Access Coding/Macros

Tags: , ,

What is OPTION COMPARE DATABASE

http://support.microsoft.com/kb/98227  Here is the KB article on this but it still doesn't explain it well.

I noticed in the MS Access Menu Tools-> Options->General Tab there is a combo box titled
New Database Sort Order
but this only has languages or the General selection

If mine is set to General how is my VBA compiler evaluating my string comparisons?  Is it using Binary or text comparisons?

Thanks
Start Free Trial
[+][-]10.21.2007 at 12:58AM PDT, ID: 20117219

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Access Coding/Macros
Tags: compare, database, option
Sign Up Now!
Solution Provided By: peter57r
Participating Experts: 2
Solution Grade: A
 
 
[+][-]10.21.2007 at 09:34PM PDT, ID: 20120840

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.21.2007 at 10:11PM PDT, ID: 20120931

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.11.2008 at 06:35PM PDT, ID: 21544211

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 07:56PM PDT, ID: 21579696

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_1_20070628