mickeyblue
New member
- Local time
- Tomorrow, 01:20
- Joined
- Nov 23, 2006
- Messages
- 2
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 'Object is Currently In';
It keeps telling me that I have a Syntax error.
Any help would be greatly appreciated.
Thanks
ALTER TABLE Objects
ADD Status Text DEFAULT 'Object is Currently In';
It keeps telling me that I have a Syntax error.
Any help would be greatly appreciated.
Thanks