SQL SET DEFAULT not working in MS Access

by

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 won’t be able to set a field DEFAULT value from DDL.

More Related Contents:

  1. SQL Access ” Count “? [closed]
  2. How do I use parameters in VBA in the different contexts in Microsoft Access?
  3. SQL multiple join statement
  4. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  5. Case expressions in Access
  6. How do I count unique items in field in Access query?
  7. Alter a MySQL column to be AUTO_INCREMENT
  8. Date Difference between consecutive rows
  9. Pivoting data in MS Access
  10. coalesce alternative in Access SQL
  11. Using Excel VBA to export data to MS Access table
  12. Why does a LIKE query in Access not return any records?
  13. How to SUM two fields within an SQL query
  14. [] brackets in sql statements
  15. How to use system username directly in MS Access query?
  16. sqlite alter table add MULTIPLE columns in a single statement
  17. can we list all tables in msaccess database using sql?
  18. Use Access SQL to do a grouped ranking
  19. Access – compare two tables and update or insert data in first table
  20. “You tried to execute a query that does not include the specified aggregate function”
  21. How to delete in MS Access when using JOIN’s?
  22. SQL: Using NULL values vs. default values
  23. Editing Record issues in Access / SQL (Write Conflict)
  24. How to save the result of a SQL query into a variable in VBA?
  25. Select query with date condition
  26. Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
  27. Microsoft Access – Case Query
  28. CONCAT equivalent in MS Access
  29. Check if access table exists
  30. ALTER TABLE without locking the table?

Leave a Comment