I'd love a solution on this as well...exactly the same issue, and now that I'm on a satellite broadband connection it's even worse than it was on dialup. (Yeah, I'm in the sticks, and the SQL server is remote)

I'm seriously about to roll back to Access03. I've got clients waiting for work and I've blown nearly a week trying to figure this mess out, even to the point of trying to download and install SS05Express, developing locally, and exporting (works great, except all the table names change on upload which hoses my query writing).

This is REALLY frustrating. Clues, anyone, please?