ALTER TABLE query SET DEFAULT problem

[inso18]

Hi Everyone.

I'm trying to alter externally the default value in a table.

I've tried this:
ALTER TABLE tblDocs ALTER COLUMN F10 SET DEFAULT "text1"
and this
ALTER TABLE tblDocs ALTER COLUMN F10 SET DEFAULT 'text1'

without success.

Does anyone know how can this be done via SQL or via DAO maybe?

Thanks in advance,
inos18

 

[genomon]

F10? Unusual field name for an Access table. Here is an example:

ALTER TABLE tblCustomers
   ALTER COLUMN Address TEXT(40) DEFAULT Unknown

Also have a look here:

http://msdn.microsoft.com/en-us/library/aa140015.aspx

Ever notice how fast Windows runs? Me neither.

 

[inso18]

Thanks for the link

I've eventually managed to change the default value using DAO.

(F10 is because it's a self generated field)