ms access - borland sdac inserted record is not shown when I try to fetch record from within the same connection -
i using borland 6 , sdac5.0 interaction ms access database. however, when insert record database , try fetch data table within same connection, newly inserted data not shown. i have noticed there bug in ms access jet4.0 regarding issue. ( https://support.microsoft.com/kb/239114 ) unfortunately system windows 7 , have checked jet.dll , have confirmed that's latest version , microsoft has confirmed issue solved. just wondering there method force database update data hard disk? can sacrifice performance in order ensure integrity of data. similar related question here , under circumstances may take approximately 5 seconds newly-inserted row visible in access database. presumably because access databases shared-file databases , access database engine may make effort "batch" commits rather hit database file instant receives insert/update query. to make update "immediately" available users (other connections) can force change database file closing co...