Just for posterity:
Test run on 22/08/2006 @ 10:34 PM
Mirror: Optus
Test type: DialupYour connection speed:
kbps: 38.99
KB/s: 4.87
Mbps: 0.04
Courtesty of Oz Broadband Speed Test.
Tuesday, August 22nd, 2006
Daily Archive
Tue 22nd Aug 2006
MS Access has no LIST data type
Posted mid-morning, filed under Asides , Rants and Raves.Well, the title sums it up. There doesn’t seem to be a way to store a list of items in a Microsoft Access database. For instance, I have an item that may belong on several categories, but I can’t just have a LIST datatype, and have a list stored in here.
Instead, I’ll have to have yet another table that has relationships, which further complicates the database. And makes creating a form for entering data more difficult.
I have an application where I need to have categories, and each category can have a parent category. However, I can’t do this in Access using one table, as tables cannot have entries that refer to items in themselves. So, I’ll need to have a Category table, and also a Category Parents table, which has the relationships in it. Bah.