Bingo! As it turn out, "name" is ok, but "date" is reserved. One solution is to just rename the field. But the other, which is what I did cuz I'm lazy, is to do what Tab says: put the field name in brackets. Thanks for all the input. I'm usually a lurker due to some email difficulties here at work. Yesterday I was working from home and it was nice to have real access to thelist. I'm still puzzled why it took so long for my posting to make it, however. :-/ - larry On Wed, 1 Nov 2000, Tab Alleman wrote: > I'm pretty darn sure that the ##'s is done correctly in his example. > > I also think that another way around those field names is to put them in > brackets, like: > > > > INSERT INTO chatter ([name], [date], comments, files) VALUES > > ('bob', #10/31/00#, > > 'just some words', 'files.jpg') > > maybe.