Hey all,
I'm using a data bound grid(dbg) with an ado data connection. My db is Access '03 using MDAC 2.7. My problem is, after data is entered into the db, the dbg isn't refreshing properly, its always one record behind. I never had this problem with SQL 2000, but Access is causing me no end of grief with this. Here's the code I'm using to display the grid:
strSQL = "Select * from MyTable"
AdoTrack.ConnectionString = cnnMydb
AdoTrack.RecordSource = strSQL
AdoTrack.CursorType = adOpenDynamic
AdoTrack.LockType = adLockPessimistic
AdoTrack.Refresh
dbgTrack.ReBind
Any ideas? Thanks in advance.
