Re: Determining Field Size

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 07/30/04


Date: Fri, 30 Jul 2004 09:59:16 -0500

On Tue, 27 Jul 2004 09:33:42 -0700, Bob Avallone <BobAvallone@discussions.microsoft.com> wrote:

¤ I am trying to find a simple way to determine the field size of a field in an Access table. I am writing in 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.
¤

Depends upon whether you are using ADO, DAO or ADO.NET and also whether you are referring to the
defined size or actual size of the field contents.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)



Relevant Pages

  • Re: VB5 to 6 upgrade
    ... the jury's still out as to whether DAO/Jet is really being phased out ... ADO, ... DAO is fine if all you ... >> Microsoft MVP ...
    (microsoft.public.vb.database)
  • Re: VB5 to 6 upgrade
    ... leave DAO behind and convert to ADO or better yet (since you're ... Microsoft MVP ... > I have a VB5 front end application to an Access 97 database. ...
    (microsoft.public.vb.database)
  • Re: cannot open dao recordset for table with SSMA_timestamp
    ... except the tiny number of things that ADO can do ... and DAO can't. ... I don't know what you're referring to. ... contact via website only http://www.dfenton.com/DFA/ ...
    (comp.databases.ms-access)
  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access 2007 and VB
    ... "unrecognized database format" ... There is a bit of confusion with ADO access to the new MSAccess ACCDB ... You could reference "DAO". ...
    (microsoft.public.vb.general.discussion)