[thelist] ASP INSERT INTO problem

[Scott Dexter]

> 
> Try changing the names of your "name" and "date" fields in 
> your database.. I
> think one or both of those might be reserved words.
> 
> INSERT INTO chatter (name, date, comments, files) VALUES 
> ('bob', #10/31/00#,
> 'just some words', 'files.jpg')

Also try putting the date in single quotes: '#10/31/00#' though my Access
knowledge is limited (we're 100% SQL Server here)

sgd