I have a waste to energy program I'm converting from Foxpro 2.5 to Access
2002. The history data file has several hundred thousand records, so I am
writing the data initially to a temp file and when completed to the history
file using a command button (Save/Print). Writing the record to the history
file works ok but, when I try to delete the record in the temp file the
record isn't deleted, doesn't even ask to confirm delete. In my test in the
immediate window in VB it worked on the first try but wouldn't work again
after I attempted to run the code from my app.

The code is:

CurrentDb.Execute "DELETE * from tbl_msw_temp where isnull(in_process)",
dbFailOnError

[in_process] field is blank when the record is completed

If I delete just the current record after save function using:

RunCommand acCmdDeleteRecord

it works.

Unfortunately I have a couple of scenarios when the routine must delete
more than the current record.

I've tried several different in_process syntax's (ie.)
 in_process=""
 in_process=" "
 in_process = null
Etc.

To no avail.

Any suggestions?

Thanks
TIM