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:
'modify table Call CreateConnection(objConn) objConn.Execute "ALTER TABLE Documents ADD n_mp3 TEXT(50) NOT NULL" objConn.Execute "ALTER TABLE Documents ADD n_wavBol TEXT(50) CONSTRAINT DEFAULT 'False'" Call CloseConnection(objConn)




Reply With Quote