Changing Column Default Value using SQL in Access 2002

C

Copa

Hello,

I am trying to Change the Default Value in the Access 2002 database using
SQL Statements (program is written in VB6). The closest information i have
come by is some SQL stuff that says you cannot change the Default Value, you
must first "drop" the default value and add it back. I have searched
through the JET documentation in Access, I have searched MSDN and the
knowledge database on microsoft for JET and SQL information. I cannot even
find the SQL statement mentioning how to do this "dropping" much more the
Access way of doing it.

If you can, Help!

Daniel Copa
Georgia Farm Bureau
478-474-8411 x2134
 
Top