Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Warren, PA
    Posts
    52

    Exclamation Unanswered: Removing a field in a table

    I am using
    CurrentDb.Execute "ALTER TABLE " & tablename & " Add COLUMN fieldname long"
    This works fine I am however looking for the code to remove this field I added.

    Thanks
    bhummel

  2. #2
    Join Date
    Nov 2003
    Location
    Warren, PA
    Posts
    52
    Quote Originally Posted by bhummel
    I am using
    CurrentDb.Execute "ALTER TABLE " & tablename & " Add COLUMN fieldname long"
    This works fine I am however looking for the code to remove this field I added.

    Thanks
    bhummel
    got it
    CurrentDb.Execute "ALTER TABLE " & tablename & " Drop COLUMN fieldname
    bhummel

Posting Permissions

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