Also, date is a reserved word, which may cause problems. If possible, I would use a more descriptive word for this table. Chris Evans chris at fuseware.com http://www.fuseware.com -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Tab Alleman Sent: Wednesday, November 01, 2000 1:07 PM To: thelist at lists.evolt.org Subject: RE: [thelist] ASP INSERT INTO problem 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. -----Original Message----- > > 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 --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !