Results 1 to 2 of 2

Thread: Alter table in access

  1. Apr 26th, 2001, 12:13 PM #1
    jdavison
    jdavison is offline

    Thread Starter
    Addicted Member
    Join Date
    Jun 2000
    Location
    Pittsburgh, PA
    Posts
    149

    Question Alter table in access

    Can somebody figure out what is wrong with this sql statement for access97. It doesnt seem to acknowledge the default value i set for the column I am adding.
    Code:
    ALTER TABLE Tbl_Partners ADD Question1 integer DEFAULT 0
    Reply With Quote Reply With Quote
  2. Apr 27th, 2001, 08:13 AM #2
    SteveFlitIII
    SteveFlitIII is offline
    Lively Member
    Join Date
    Aug 1999
    Location
    Blackpool, England
    Posts
    87
    append??
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width