Where's my data??? (MS ACCESS, OLE DB, DataGrid)
Posted on 2006-07-21
1. I have a DataGrid.
2. I have a Form.
3. I have an Access DB.
4. I have a dataset.
The Form data is inserted into my DB in an isolated transaction.
After that transaction has completed, I reload my dataset which is binded to the DataGrid. I use a connection instance for me insert transaction, and another connection object for my "selects". Even though both connection objects are created from the same connection string (appended below), the data seems to not be updated with a follow up my completed transaction with a search on the newly inserted data.
Basically the data I'm submitting is not show up in my datagrid. It's like I have to wait a few seconds and search again to find it. Is Access really that slow. Why would it complete my insert and transaction if it's not done.
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=$$$\DocuBase.mdb;Mode=Share Deny None;Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False