Not sure if this will help, I took this from the SQL Books online. With a search on Alter Table.
Add a nullable column with default values
This example adds a nullable column with a DEFAULT definition, and uses WITH VALUES to provide values for each existing row in the table. If WITH VALUES is...
You also might try decompling the mdb file and then recompling it again. This has worked for me.
"C:\Program Files\Microsoft Office\Office\msaccess.exe" /Decompile C:\YourFolder\YourMDBFile.mdb
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.