database refresh

If I add a record to my access database using sql or ado the record is created. I then recreate the recordset to include the new record however, this record is not always found. I think it is the database refresh or something. Does anyone know of any way in which I can refresh the database or recordset without having to put a sleep or time delay before recreating the recordset again?

I hope this has made sense.
Thanks for your help
Paul

The property your looking for is requery. This will cause your recordset to be refreshed, and be set to the beginning of the table.

Thanks but I've tried that. I actually rebuild the recordset

Set tempprecordset = LISTLINKDB.OpenRecordset("select * from tempproduction where flistref = '" & listref & "';", dbOpenDynamic)

before trying to read the records but the new record I have created is not found until I recreate the recordset twenty or so seconds later.

Are you using a database that is on a network, or is everything local to your machine?

-r

Currently it is local to my machine but it will be networked eventually

It looks like you are using ODBCDirect, have you tried using dbRunAsync as an option on your query.