<p>I am attempting to use linq to shape list of data into a particular shape to be returned as Json from an ajax call.</p>

<p>Given this data:</p>

<pre><code>var data = new List&lt;string&gt;();
data.Add("One");
data.Add("Two");
data.Add("Three");
</code></pre>

<p>And this code: ** Which is not correct and is what needs to be fixed!! **</p>

<pre><code>var shaped = data.Select(c =&gt;
    new { c = c }
).ToList();

serializer.Serialize(shaped,sb);
string desiredResult = sb.ToString();
</code></pre>

<p>I would like <code>desiredResult</code> to be:</p>

<pre><code>{
    "One": "One",
    "Two": "Two",
    "Three": "Three"
}
</code></pre>

<p>but it is currently:</p>

<p><code>{ "c" : "One" },{ "c" : "Two" }</code>, etc. </p>

<p>One problem is that on the left side of the object initializer I want the value of <code>c</code>, not <code>c</code> itself...</p>

The ALTER TABLE syntax is only supported in Jet 4.0/ACE while in
ANSI-92 Query Mode. Try an ADO connection e.g.
CurrentProject.Connection.Execute "ALTER TABLE myTbl ADD COLUMN myColumn DECIMAL(9,4)"