Refresh problem with ADO & Access


I'm facing refresh problem when using ADO and Access 2000
Database. The ADO version is 2.5 and I'm using MS Jet 4.0 OLE DB Provider
to open the Access 2000 database.

The problem is any changes made(in this case I mean only add or delete
record) to the database by other users could not be
reflected on the grid...due to nature of the available cursor
type... i.e. Dynamic, Keyset, static, forward only. I did try
to change to Dynamic but the grid could not show any data at all.

Is there an alternative solution for this ?

Thanks in advance for any help.

The new Delphian