Peter,

Make sure the primary key you're using in your view is indexed in the base table. When you update a remote view it creates a SQL UPDATE statement with a WHERE clause based on the primary key. On such a small table this should work very fast if the primary key is indexed.

>Hi! I have a database of 36,000 records and access it using a remote view. The records are small (5 integer fields) and it takes 7 seconds to update the view across the network. Is this a normal speed? Is it always so slow? Accessing the table directly, even through the network is instantaneous, but refreshing several of these types of views makes things slow down considerably. If this is the way it is, I can deal with it, but maybe I have some setup wrong, or some ODBC connection incorrectly set up.
>
>Any help greatly appreciated.
>
>Peter