Lets say I add a record to a table. Then I immediately fill a combo with records that include the new record. The record does not show up. However, if I wait a second or 2, re-run the query, then it will show up. Is there and option I can use with my query (I'm using ADO commands on an Access database)that will force the refresh (or whatever is causing this)on my database/Query?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access DB--- Non-immediate updates. Why?
- Thread starter Misled
- Start date
I would look at the cursor you are using. If you are using a server side, keyset cursor this may the reason. I would use a server side , dynamic cursor. Althougth if this is a many user app, this choice could cause other locking problems.<br>
<br>
C
<br>
C
- Thread starter
- #4
I am using client side disconnected recordsets. Also, as I said, when I run the query the recordset is already updated with the new record but the query does not "see" the record until a few seconds later. FYI..... If you are looking at the table in access, use the VB program to add a record, the new record auto displays in the access table a few seconds later. I suspect there is a way to force the access DB to give all the latest updates before a query is run. Does anyone know what I am talking about?
Sorry I program using Oracle & SQL Server. Don't know much about access. Once you run the updatebatch method on the disconnected recordset it should write all the changed records back to the data source. I can't understand any delays. Maybe you should also post in the access forum.<br>
<br>
C<br>
<br>
C<br>
- Status
