各位大大：    我想修改 Access 資料庫的結構 ─ 欄位的 AllowZeroLength 的屬性，請問如何不透過 Access，而使用程式碼或 SQL 指令修改？    謝謝！

參考: http://groups.google.com.tw/groups?hl=zh-TW&lr=&ie=UTF-8&oe=UTF-8&th=30344c654a0f37e2&rnum=4 lj (linda100@bellatlantic.net) 的回覆:

const
  DAOMSJet = 'DAO.DBEngine.35'; // 'DAO.DBEngine'
   
var
  Dao, db, tabledef, thisfield: variant;
begin
  try
     Dao := CreateOleObject(DAOMSJet);
     db := dao.OpenDatabase('d:\workdir\db1.mdb');
     tabledef := db.tabledefs['MYTABLE'];
     thisfield := tabledef.fields['FIELD2'];
     thisfield.allowzerolength := True;
  finally
     try
       db.close;
     except
     end;         dao := unassigned;
  end;
end;

--- 每個人都是一本書