Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    The sunny side of the Alps
    Posts
    230
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add column in Access with ASP

    Hi!

    How can I add new field or new table in Access database with ASP?

    I have tried to use
    Code:
    sSQL = "ALTER TABLE clani ADD COLUMN Bilten c(5) NULL"
    to add column named Bilten (text, length = 5), but i get
    Code:
    Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 
    
    [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.

    Bostjan
    Last edited by bostjank; 01-24-2003 at 11:46 AM.

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts

    Re: Add column in Access with ASP

    Originally posted by bostjank sSQL = "ALTER TABLE clani ADD COLUMN Bilten c(5) NULL"
    shouldnt this be :
    "ALTER TABLE clani ADD COLUMN Bilten char(5) NULL"

    or varchar ofcourse
    I am the luckiest man in the world

  • #3
    Regular Coder
    Join Date
    Jul 2002
    Location
    The sunny side of the Alps
    Posts
    230
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks.

    Bostjan


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •