Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Kingwood, Texas, USA
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ALTER TABLE syntax (Access 97 SR-2)

    Right now I have a query like this:
    ALTER TABLE MyTable ADD COLUMN MyColumn Number;

    This adds a column named MyColumn whose data type is Number and whose field size is Double. (Double is evidently the default.) I want to specify "Long Integer" but I can't seem to get the syntax right. Can anyone show me how to do this?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ALTER TABLE syntax (Access 97 SR-2)

    Use :
    ALTER TABLE MyTable ADD COLUMN MyColumn Long;
    Francois

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Kingwood, Texas, USA
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ALTER TABLE syntax (Access 97 SR-2)

    Thanks! I just ran the query and it worked. Of course I thought I *had* tried that one, but obviously I must have mis-typed something. I appreciate the help.

Posting Permissions

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