I have read through about a 4 pages of threads trying to find a solution and it could be there isnt one. I am using ODBC provider to connect to my Access database. I need to add two fields and set one field default settings to 'FALSE'.

The following gives me a syntax error in constraint clause. I have tried a variety of diffrent ways to do this, but I am beginning to think, you cant set the default settings.

I would appreciate any help.



VB Code:
  1. 'modify table
  2.     Call CreateConnection(objConn)
  3.         objConn.Execute "ALTER TABLE Documents ADD n_mp3 TEXT(50) NOT NULL"
  4.         objConn.Execute "ALTER TABLE Documents ADD n_wavBol TEXT(50) CONSTRAINT DEFAULT 'False'"
  5.     Call CloseConnection(objConn)