I'm using Promatrix and it works fine on Local views. When I use Remote Views it also works on data I converted as far as finding a file. Only the newly inserted record cannot be found. It does exist on the SQL Server and can be queried there.