Visual Basic: Bi-Directional Programming

Creating Middle East Database Applications

See Also

Middle East sort order support is included in the Jet database engine to enable searching, sorting, and display of Middle East and Latin text in a widely accepted collating sequence. Separate sort orders are provided for Arabic and other right-to-left Middle East languages.

Each Middle East sort order accommodates both Latin and the appropriate Middle East language text. For example, the Arabic sort order describes the collating sequence for Latin (primarily English and French) and Arabic text.

Refer to the discussion of the CreateDatabase method in online Help for information about how to create a database with Middle East collating order. Databases with Middle East sort orders are supported only when Visual Basic 6.0 runs in a bidirectional 32-bit Windows environment.

Visual Basic 6.0 running in a non-bidirectional 32-bit Windows environment cannot open Visual Basic 6.0 databases created with a Middle East sort order. The database must be compacted with General sort order in a bidirectional 32-bit Windows environment before it can be opened. This can be done programmatically using the CompactDatabase method or interactively using the Compact Database command of Microsoft Access 97 or later.