Hi

I'm trying to insert data from a Form into an Access DB. (Wins 2000, Access
2000) I have a connection set up and was able to see and retrived data from
the Access DB for display. My problem is I can't insert new data to the DB.
When clicked Submit on the form it keep on gives me this ERROR.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
/rg2intranet/directory/site_insert.asp, line 90

Could someone please help, i've been sitting on this problem since
yesterday...

Thanks
-Dave

Problem Fixed! Thanks to a friend's help.

Cause: reserved word in Access Data Field
Solution: Rename Data Field name in the Access DB