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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sql db default value in access 1
Using Access 2007 to connect to SQL 2
web form getting data to SQL Backend 8
Access 2007 and ADP to SQL Server 2005 in Vista 13
Using mirrored sql 2005 db with a ms access adp project 1
Setting DEFAULT to empty string using SQL 2
Get constant current SQL Server Table data to Access 2000 FE 3
Access 2002/XP Access Project (ADP) and SQL Server 2005 3

Top