Modifying Access2000 table structure/properties? RRS feed

  • Question

  • I've been trying to find a way to write an app that will take an exisiting Access2000 database and modify the tables so that they have default values defined. I can add new tables and set the default values at that time, but I haven't been able to find out how to do it for existing tables.
    Monday, July 23, 2007 7:35 PM

All replies

  • It seems the command needed the data type specified again in the ALTER TABLE command I was trying.

    Code Snippet
    conDB.Execute("ALTER TABLE Test ALTER COLUMN Frogs TEXT(20) Default 'Fred'", out obj, 0);


    worked, but not specifying TEXT(20) failed.

    Monday, July 23, 2007 7:51 PM