I went to update the validation calculation for a field and got an error: "Unknown Error: 1218." and I am unable to enter the validation calculation.

A inspection of the database shows that this happens on 23 other fields.

The fields that have the error are shown to be validated by a calculation in the field definition but not in the DDR.

I tried to Recover the database but it did not find any problems and problem I am having still exists in the recovered copy.

I checked all of my backups and it looks like the problem happened three weeks ago.

The database is in the final stages of developement so there is no data I actually care about. I just need to get it working and to make sure I can trust it again.

The only thing I can think of is to create a new field and change all of the layouts, calculations and scripts to use the new field and then delete the old field.

Is there any way I can take the DDR from the current database, edit the 23 field definitions manually and recreate the database?

I am open to third party solutions since this is going to be a lot of work to fix everything.

you might try FMRobot from New Millennium

FMRobot

It can create tables from a DDR.

Also after you get the New table back in, just rename the old table with "OLD" or something. Then after the new table is in place just adjust all the table occurences that referenced the "old" table to reference the "New" version. That will should do it.

Todd