this is the third problem I have !! I can write to the access DB, close the db set the ADO object to nothing and in a subroutine that opens the DB again the record is not found! The record can be viewed after its been added direct on the DB so its there. Ive had to get aroudn the problem (which is intermittent) by if the eof was found to loop around 30 times so on each loop doing a requry of the record set. It usually finds the record after 1-5 loops - other timnes it falls over and needs more than 30 loops!!!! This is a crazy problem.<BR><BR>Im running access 97 DB on IIS4<BR><BR>Any ideas - maybe the server needs a patch or something - thanks