Multi-Valued Fields in Access 2007

Yikes! Access 2007 will, in about the ugliest way possible, allow multivalued fields to be created in the user interface, as described here.

Deep down, the multivalued fields are actually internally handled in a relatively clean way, however there is not a way for even a developer to actually get to the proper representation in this version. Maybe next time.

This is the fundamental flaw I have often seen in MS Access is how Access lets you get to 80% of the solution, in no time, while the remaining 20% of the solution, so that the application actually is properly constructed, is almost impossible to reach.

Posted by Douglas Reilly at 11:37 AM  Permalink