It sounds to me like you need to look at the connection's CursorLocation
property. Setting this to client-side gives you full access to the data
because it's "disconnected" from the server-side. You can update it whenever,
but you'll have unrestricted access to the current (as of last update) data
meanwhile.

Here's a link to some samples/examples that might help.

http://www.appspro.com/conference/Da...rogramming.zip

The package includes a Word document named "DatabaseProgramming.doc". Read
it through fully.

HTH
Regards,
Garry