Search results

Thanks Graham. Does anyone know of a way to create default values using the standard SQL interface?

I am currently attempting to use SQL in Access to alter a table by adding a new attribute and giving it a default value. Creating the attribute is fine but i keep getting an error when attempting to assign a default value. My code is as follows: ALTER TABLE Objects ADD Status Text DEFAULT...