Alter Access field online

AndyUK

I have a website which has a database as most of the source. I am looking to alter one of the table field default properties without having to download the whole database amend the field and upload again. (upset the visitors) . I understand there is aDBS script reference around but can not find any info to help me.
1. The table name is VILLAGE
2. The field is E_HOUSE
3. I need to set the default property in the design to 1
4. Amend all records so that they have a 1

I have seen some script similar to this and wonder if someone could provide the correct script:

Code: Select all

[ALTER]
VILLAGE
ALTER#E_HOUSE#int#NULL#1#
ALTER#E_HOUSE#default#1#
END

I am not sure if the text in green will do what I am after
Any help would be appreciated
andy