<div>
Hi,<br />
<br />
pls try<br />
<br />

<pre><code id="code-20-39849378-1">myRst.Fields.Count </code></pre>
Regards
</div>


Hi,

pls try



myRst.Fields.Count 

Regards

<div>
Hi<br />
<br />
I connect to the database via a connection string so am looking for SQL code to do this
</div>


Hi

I connect to the database via a connection string so am looking for SQL code to do this

<div>
Hi,<br />
<br />
pls try
<pre><code id="code-20-39849427-1">SELECT COUNT(*) AS ColumnCount
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='tablename';</code></pre>
</div>


Hi,

pls try

SELECT COUNT(*) AS ColumnCount
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='tablename';

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
What VB.net code would I use to count the number of columns in an Access table?<br />
<br />
Thanks
</div>
</div>


Hi

What VB.net code would I use to count the number of columns in an Access table?

Thanks

VB.net Count Columns in an Access table

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.