Error adding new records

I get the following error when add ing new records to Webwiz. 9.66

I checked the access table and noticed that thread_id is not set to auto increment ( i thought it was like this in an older version).

Is this my problem? If not, any ideas what is going on?

I changed it to be not required and it saves with a Null (which is obviously not right).

Any ideas what I should do?

Cheers
David

Server Error in Forum Application
An error has occurred while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_Access_save_new_post_data
File Name:- new_post.asp

Error details:-
Microsoft JET Database Engine
The field 'tblThread.Thread_ID' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.


Edition: Free Express Edition
Running Version: 9.66
Database Backend: Access

This is not a new installation.

It was upgraded from an older version of Web Wiz to version 9.

Access will not let me convert an existing column to AutoIncrement if it already has data.

So I am a bit stuck.

Any other ideas?

Cheers
David

Bruce is right.. Hopefully you kept a backup of your DataBase... If not then you might have to reinstall the WWF again.. with a clean install.. not unless you want to go through line by line to fix the code in your Database.