Hi,
I need to change the "DEFAULT" value of a Text field and found the following MSDN link:
http://msdn.microsoft.com/en-us/library/aa140015(office.10).aspx#acintsql_alttable
the link is for Access 2000. There is a sample to alter the default of a column in a table. I took it and changed it for my needs. It looks now as following:
ALTER TABLE Auftragsstand ALTER COLUMN Stand Text(50) DEFAULT _gelb;
I tried it with an Access 2000 and an Access 2003 database. The word "DEFAULT" is not recognized. Does anybody know a solution for this? Thank you!
HorKar
I need to change the "DEFAULT" value of a Text field and found the following MSDN link:
http://msdn.microsoft.com/en-us/library/aa140015(office.10).aspx#acintsql_alttable
the link is for Access 2000. There is a sample to alter the default of a column in a table. I took it and changed it for my needs. It looks now as following:
ALTER TABLE Auftragsstand ALTER COLUMN Stand Text(50) DEFAULT _gelb;
I tried it with an Access 2000 and an Access 2003 database. The word "DEFAULT" is not recognized. Does anybody know a solution for this? Thank you!
HorKar
