Finding Field Size

[bob@metaprosystems.com]

I am trying to find a simple way to determine the field size of a
field in an Access table. I am writing a VB.NET Windows application. I
would like a code snippet that I can get to work. I found some example
on the Web but I couldn't get them to work. I will be grateful if you
can help me with this.

[Rick Rothstein]

Re: Finding Field Size

Almost everybody in this newsgroup is using VB6 or lower. While you may
get a stray answer to VB.NET questions here, you should ask them in
newsgroups devoted exclusively to .NET programming. Look for newsgroups
with either the word "dotnet" or "vsnet" in their name.

For the microsoft news server, try these newsgroups...

microsoft.publi c.dotnet.genera l
microsoft.publi c.dotnet.langua ges.vb
microsoft.publi c.vsnet.general

There are some others, but these should get you started.

Rick - MVP



<bob@metaprosys tems.com> wrote in message
news:d64f699a.0 407231135.73791 92c@posting.goo gle.com...[color=blue]
> I am trying to find a simple way to determine the field size of a
> field in an Access table. I am writing a VB.NET Windows application. I
> would like a code snippet that I can get to work. I found some example
> on the Web but I couldn't get them to work. I will be grateful if you
> can help me with this.[/color]

[M. Posseth]

Re: Finding Field Size

hmmm ,,,

well i am probably an exception, for me VB is VB even if it has .Net
behind these two beloved letters

i only program VB6 or higher :-)

To answer your question Bob, ADO.NET lacks support for DDL this wil be
added in future versions for the time beeing you should grab back to ADOX
( hey we now that from VB6 :-) )
with ADOX you can read complete data definitions of the ACCESS database (
table names , fieldnames , fieldtypes , sizes etc etc )

In the near future this will be replaced by a managed schema object model
for ADO.NET will replace the ADO Extensions for DDL and Security (ADOX). The
future schema object model is based on the dataSet object and supports
read/write access to Table, Column, and Constraint objects.

M. Posseth MCP





"Rick Rothstein" <rickNOSPAMnews @NOSPAMcomcast. net> wrote in message
news:nLmdnfQP2p 8RMJzcRVn-rA@comcast.com. ..[color=blue]
> Almost everybody in this newsgroup is using VB6 or lower. While you may
> get a stray answer to VB.NET questions here, you should ask them in
> newsgroups devoted exclusively to .NET programming. Look for newsgroups
> with either the word "dotnet" or "vsnet" in their name.
>
> For the microsoft news server, try these newsgroups...
>
> microsoft.publi c.dotnet.genera l
> microsoft.publi c.dotnet.langua ges.vb
> microsoft.publi c.vsnet.general
>
> There are some others, but these should get you started.
>
> Rick - MVP
>
>
>
> <bob@metaprosys tems.com> wrote in message
> news:d64f699a.0 407231135.73791 92c@posting.goo gle.com...[color=green]
> > I am trying to find a simple way to determine the field size of a
> > field in an Access table. I am writing a VB.NET Windows application. I
> > would like a code snippet that I can get to work. I found some example
> > on the Web but I couldn't get them to work. I will be grateful if you
> > can help me with this.[/color]
>[/color]