HTTP Error 500 - Difficulty with cfinsert

I am able to insert data with cfinsert without difficulty into my access tables as long as they are simple tables without columns containing autogenerated values such as datestamps or autogenerated IDs. However, I cannot seem to insert data into tables that do contain autogenerated values, I keep receiving the generic HTTP 500 error message, driving me nuts! Any advice?