09-28-2000, 10:18 AM
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
09-28-2000, 11:02 AM
The property your looking for is requery. This will cause your recordset to be refreshed, and be set to the beginning of the table.
09-28-2000, 11:13 AM
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.
09-28-2000, 04:46 PM
Are you using a database that is on a network, or is everything local to your machine?
09-29-2000, 03:53 AM
Currently it is local to my machine but it will be networked eventually
09-29-2000, 09:40 AM
It looks like you are using ODBCDirect, have you tried using dbRunAsync as an option on your query.