array data type in table?

[djw]

I am pretty new to Access/VBA and do not really know SQL. I was
wondering if it is possible to use an array data type in a table?

I saw something online using SQL that was along these lines (in SQL
For Dummies):
CREATE TABLE CUSTOMER ( CustID INTEGER PRIMARY KEY, Phone CHARACTER
VARYING (15) ARRAY [3]);

I can create a table and fields using VBA & SQL but I cannot seem to
get an Array to work.

Thanks,
David

 

[John W. Vinson]

I am pretty new to Access/VBA and do not really know SQL. I was
wondering if it is possible to use an array data type in a table?

I saw something online using SQL that was along these lines (in SQL
For Dummies):
CREATE TABLE CUSTOMER ( CustID INTEGER PRIMARY KEY, Phone CHARACTER
VARYING (15) ARRAY [3]);

I can create a table and fields using VBA & SQL but I cannot seem to
get an Array to work.

Thanks,
David

Access2007 (but not prior versions) allows an abomination called a MultiValue
Field. This code *might* be relevant to such a field, though I have not seen
code like it before; it would be interesting to know the context.

A multivalue field is actually implemented "under the covers" with a proper
one-to-many relationship to a second table; unfortunately that table isn't
exposed either in user view or programmatically, without a whole bunch of
rigamarole. Most serious developers would avoid ever using such a field.