How to Modify a field size


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to Modify a field size

  1. #1
    Ronald Saikali Guest

    How to Modify a field size

    Hello,

    I have created a text field of 20 char , now I want to change it to 10
    char.
    I did not fing any SQL command in Access to do so.
    in SQL Server , we have ALTER Table ALTER Column ..... ,
    what can I use in SQL with Access Jet engine , or using the database
    object to be able to change the field size ?
    I am using VB.

    Thank you

  2. #2
    Russ Guest

    Re: How to Modify a field size


    Ronald Saikali <ronald.saikali@iname.com> wrote:
    >Hello,
    >
    >I have created a text field of 20 char , now I want to change it to 10
    >char.
    >I did not fing any SQL command in Access to do so.
    >in SQL Server , we have ALTER Table ALTER Column ..... ,
    >what can I use in SQL with Access Jet engine , or using the database
    >object to be able to change the field size ?
    >I am using VB.
    >
    >Thank you


    Ronald,
    I don't think Acess supports ALTER Column. Although, you can use ALTER Table
    to Add or Drop a column. So a work around would be to create the new, smaller
    column, move the data in the old column over, then drop the old column.

    Or you could use ADOX or DAO to do the same thing.

    Hope this helps,
    -Russ.




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center