SQL SET DEFAULT not working in MS Access
Support for DEFAULT was included in Access DDL with Jet 4 (Access 2000). However it can only be used in DDL executed from an ADO connection. This worked with Access 2007. CurrentProject.Connection.Execute “ALTER TABLE MyTable ” & _ “ALTER COLUMN field2 SET DEFAULT “”foo””;” Note if your db file is Access 97 or earlier, you … Read more