Adding a field to a table

[belmontpines]

I know how to add a field using code, I tried to insert a
hyperlink field into a table using the following but it
doesn't want to play, any ideas

dbs2.Execute "ALTER TABLE settings ADD COLUMN rc2ftp
hyperlink"

Nigel

 

[Tim Ferguson]

I know how to add a field using code, I tried to insert a
hyperlink field into a table using the following but it
doesn't want to play, any ideas

Use a text field; and get the UI to do all the hyperjumping.

Tim F