Could anyone please tell me the command for a yes/no field in an Access database when using Create_Table? That is when I do: <BR>strSQL = "CREATE TABLE Pages (PageID Counter, PageName Memo, Module YesNo)" what replaces the YesNo in this example to create the field? I get "Syntax error in field definition." <BR>Also, I'm looking for a way to exclude system tables when I run: Set TablesRS = Connect.OpenSchema(AdSchemaTables)I've tried a number of options on both these problems but without *knowing* the correct syntax one is pretty much lost. Help would as always be appreciated.