Hi, Deano.
dbs.Execute ("ALTER tblCCOccurrences ADD COLUMN Year1 Text;").
This gives me;
Syntax error in ALTER TABLE statement. 3293
It's missing the TABLE keyword. And unless you indicated exactly how many
characters of text, the new column will be 255 characters, probably not what
you want. Try the following syntax (watch out for word wrap, as this is all
one line):
dbs.Execute ("ALTER TABLE tblCCOccurrences ADD COLUMN Year1 Text(4);"),
dbFailOnError
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs:
www.DataDevilDog.BlogSpot.com,
www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Deano" <de***@mailinator.comwrote in message
news:5a*************@mid.individual.net...
Hi,
I just want to add a text column to a table in my code. I can't find a
simple example of this.
dbs.Execute ("ALTER tblCCOccurrences ADD COLUMN Year1 Text;").
This gives me;
Syntax error in ALTER TABLE statement. 3293
What am I missing here?
thanks