469,106 Members | 2,310 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

Finding Field Size

bob
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.
Jul 17 '05 #1
2 3858
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.public.dotnet.general
microsoft.public.dotnet.languages.vb
microsoft.public.vsnet.general

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

Rick - MVP

<bo*@metaprosystems.com> wrote in message
news:d6**************************@posting.google.c om...
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.


Jul 17 '05 #2
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" <ri************@NOSPAMcomcast.net> wrote in message
news:nL********************@comcast.com...
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.public.dotnet.general
microsoft.public.dotnet.languages.vb
microsoft.public.vsnet.general

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

Rick - MVP

<bo*@metaprosystems.com> wrote in message
news:d6**************************@posting.google.c om...
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.

Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by Sean Ross | last post: by
reply views Thread by Dan Muey | last post: by
5 posts views Thread by sdowney717 | last post: by
6 posts views Thread by Maxi | last post: by
3 posts views Thread by Linh Luong | last post: by
2 posts views Thread by ElkGroveR | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.