Datagrid not refreshing

[dmkAlex]

I have a screen where the datagrid is tied to adodc recordset. After I deleted a record from the underlining table, I want the datagrid to refresh to omit the record that was deleted.

I use the data.refresh and datagrid.refresh command after the deletion query was executed. The datagrid would not refresh in runtime. However, if I step through the routine, the record would be gone.

It looks like the runtime is too fast for the screen to update. I tried putting a for loop to do 100 times of doevents and it still would not refresh.

Any suggestion on how to synchronize the screen even in run time?

Thanks.

Alex

 

[Golom]

Try refreshing the cache

Dim cnn As New ADODB.Connection
Dim je As New JRO.JetEngine
   
[COLOR=green]' Open the connection[/color]
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
         "Data Source = myDatabase.mdb;"
   
[COLOR=green]' Refresh the cache to ensure that the latest data
' is available.[/color]
je.RefreshCache cnn

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[dmkAlex]

I use the following connection string for the database:

dFile = "C:\Documents and Settings\test\My Documents\eBayTrx.mdb"
Set db = OpenDatabase(dFile)

And I refresh the table as follows:

data2.Refresh
NeedGrid.Refresh

It didn't work.

Any suggestion in how to do the cache refresh. The method I use doesn't support the RefreshCache methoo.

Thanks.

Alex

 

[Golom]

Something strange here. Your first post said that you were using a datagrid tied to an ADODC recordset but your second post uses Opendatabase and that's DAO syntax. Which one are you really using?

If you're using both then note that ADO and DAO are not synchronized and you will always experience the problems that you are seeing.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[dmkAlex]

I am using an older version of the Access as my database bucket and I am more familiar with the older connection string.

However, the datagrid object seems not friendly with the old connection string. It requires Adodc object which I connect in my form load:

data2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & db.Name
data2.CommandType = adCmdText

data2 is the name for the adodc object and I bounded data2 to my datagrid.

Thanks.

Alex

 

[Golom]

Hmmm ...

Still not coming together.

Why are you opening a DAO database using

 Set db = OpenDatabase(dFile)

?

As I said before ... DAO and ADO are not synchronized and opening both DAO and ADO connections to the same database can often cause problems. Perhaps you should be doing something like

data2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\Documents and Settings\test\My Documents\eBayTrx.mdb" 
data2.CommandType = adCmdText

and get rid of the "Opendatabase" method entirely.

You may also consider that you can use an ADO recordset as the rowsource for an ADO Datagrid. An ADO Data Control (ADODC) is usually not required.


[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]