>But I am not using the connection to do any data updates. The data entry/updates are done via local views to VFP tables. The connection is only used for lookups, data validations, etc via SQL Passthrough.
>
Ok, now I undertand. You have your connection to VFP database, right?
If yes, I have no exact answer. Try to use 'FLUSH' command after updates. Try to find something like 'requery' for crystal reports ActiveX (for case when data buffered without real query to physical data), etc.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.