Hi,

I working on an application and I have inserted some data into a table within a sql database, and the date has obviously been entered in the wrong format, the problem is I can't amend or delete the record from the table, everytime I click away from the record I get the following error:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

Any ideas on how I can remove this record

Many thanks
Peter

Press Esc, so the record is not inserted after all???



---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

The record is already inserted I can't seem to delete it

Right. I thought you were still in the EM trying to insert a record.

You can delete the record through code. Open the Query Analyser, and execute the code in the offending database:

DELETE FROM MyTable WHERE IDColumn = IDOfOffendingRecord.

When you press F5, the code will run and the record will be deleted.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.