Delete affects subsequent insert

[jjob]

I have a table that has no key fields, it contains sets of data identified by a company, a code (the rows also contain a date) so it could be that all 3 fields could form a composite key, but as the sets are deleted and inserted as blocks, (always in that order, DELETE old set of data, then INSERT new set of data), never being accessed as an individual row, I've not done so. However, since setting up a new system to allow me to do development work on a portable, the DELETE of a set of data works, but the insert, whilst it gives no errors, does not seem to insert data, UNLESS I don't call the DELETE, in which case the new data is inserted and I end up with the old set and the new set of data. I assume this has to be something to do with the new Database instance I've installed, but am at a loss as to know exactly what.

I use stored procedures and both can be stepped through and work perfectly.

Can anyone help with any suggestions?

Thanks in anticipation.

John