G
Guest
Access 2003 - I need to change an existing column by adding Date() to the
default property but cannot find the correct syntax. Here's one of many
statements I've tried:
VSQL = "ALTER TABLE Classes ALTER COLUMN StartDate SET DEFAULT Date();"
I have to do this from VBA, not by simply changing the design of the table.
Should I be using ADO instead? If so, can anyone point me in the right
direction?
default property but cannot find the correct syntax. Here's one of many
statements I've tried:
VSQL = "ALTER TABLE Classes ALTER COLUMN StartDate SET DEFAULT Date();"
I have to do this from VBA, not by simply changing the design of the table.
Should I be using ADO instead? If so, can anyone point me in the right
direction?