What solutions would you recommend for the following requirements:
1. Sales force is distributed accross the country. Sometimes connected,
sometimes not.
2. Need to see data in a grid format, web or windows based. Would be nice if
it was launched from the intranet portal.
3. Would like the solution to link to originate from a web portal. If not
connected, redirect or go somwhere else?
4. Clients are on I.E. 6, strict security on windows xpsp2 (firewall),  and
do not have sql 2005 express. Users can get the framework 2.0 loaded.

I've researched windows app using clickonce. I'm having trouble finding out
what the security guidlines are for downloading a dataset and persisting it
while disconnected. Am I barking down the wrong path? Should I go all HTML
and just make them save pages down to their local box (not very elegant)?