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

On Wed, 29 Oct 2008 11:05:50 -0700 (PDT), djw <(E-Mail Removed)>
wrote:

>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.
--

John W. Vinson [MVP]