Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Unanswered: Altering the data type of an Column in Access

    Hi
    I have a database (Access 2000) with a field called ID which is numeric.
    Do you know how can I change it to be a primary key, autonumeric and not null using ASP?

    I'm not sure about the ALTER TABLE syntax

    Thanks ain Advance

  2. #2
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    Check out http://www.w3schools.com/sql for the basics of SQL statements.

    Cheers,
    Andrew
    There have been many posts made throughout the world.
    This was one of them.

Posting Permissions

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