ADO + Datagrid + Refresh

[Iain Boyd]

I am using a Datagrid bound to an ADO Data control which is accessing an ACCESS97 database.

I am updating one of the database tables directly via the .Update and .Delete methods.

When I refresh the Data control 'nothing' happens.

A MS Knowledge Base article (Id = Q248833) seems to refer to a similar problem when using DAO. The given resolution is to 'Move the Microsoft DAO 3.51 type library up in priority to just under the Visual Basic type libraries.'.

Can the failure to refresh an ADO Data control be solved in the same way?

If so, how does one go about 'moving the type library up in priority'?

If not, can anyone suggest a solution?

[Randman]

check out these
Q191457
Q216666

I'm pretty sure these are what your looking for. just search through the kbase.

[Iain Boyd]

Randman,

Many thanks for your suggestion.

However, I am not using the Data Environment.

I have tried using all combinations of .requery of the recordset and .refesh of the data control and datagrid and although the datagrid is refreshed it does not display the record I have just added.

I am completely confused!

[pardede]

with ADO, you need to rebind the data bound controls by resetting its DataSource property to it's own, like:

Set txtName.DataSource = txtName.DataSource