Problem re-opening Access databse table

Hi
I hope someone can help me with the following problem:
I have a form the shows table information in a stringgrid.
On that form their is also a refresh button.
When I click the button 12 tables will be refreshed, just by a closing and
opening each table.
This works fine as long as no table in de database has been changed.
Is there a change however then one of the tables will not reopen Error
message is 'Access violation', or sometimes 'Operation not allowed on a
closed dataset'.

So I think that I must have changed something but I cannot find out what
that is. I am 100% sure that the error-table itself is not changed. The only
thing that happened to that table is that it is located at a certain
position prior to the close/open action for the refresh.

I cannot find any relevant difference in the definition for the 12 tables.

Using the debugger I compared all the properties for the dataset in an
OK-situation with an Error-situation -> No differences found.

Question:
How do I trap the error ?

Please help!
E. Vrije


.