kexi project
Rapid Database Application Development
"Microsoft Access for Linux"

Home Download FAQ Support Features Handbook Screenshots Screencasts Compile Kexi Development Authors Contact License Sponsorship Translate This Site

wiki navigation:

Front Page
[info] [diff] [login]
[recent changes]
[most popular]
You can donate
to Kexi Project:
Via PayPal

Spread the word about Kexi!
Get Kexi Now!

Built on the KDE technology

Member of the Calligra Suite

No Software Patents!

MS Access Stupidities

See also: MSA Annoyances

  • Forms:
    • We are in XXI century, but form styles (available in Form Wizard) are still generated with 16 colors.
  • MSA allows users to use any (non latin-1) characters and then they are wondering why their database does not work when on MS Windows with other GUI language. Example cryptic error message:
Users are then forced to find and rename objects by hand to fix the bug. Moreover, MSA itself creates non latin-1 identifiers automatically, e.g. for "Details" identifier - "Szczegóły" in polish. This is example of badly designed core functionality that cannot be patched.
  • Flawed sort order for text (MSA version 2000 or newer): dash characters (-) are ommited while sorting. For example the result can be as unexpected as the following:

instead of:

Comment: this is hidden (not well undocumented) bit of Access' sorting startegy. Moreover '.' or '_' characters are not affected, what looks inconsistent. As a result, there may be invalid query results or reports if user depends on "typical" sorting order.

Kexi - "MS Access for Linux" ... and Windows
© 2002-2007 Kexi Team
This content is available under GFDL
Last edited: May 21, 2006 by js, visited 0 times.