Here are a few things that will bite you.
Be very aware of how much information you are really requesting. For example, if you have a large number of pull-down lists on a screen, populated by SQL statements, the screen will still load quickly on a LAN. It may be horribly slow when you are on a slower wan, especially as the number of users goes up.
Consider that your test database is small, and your production database will be much bigger. A query that does not use an index still runs faston a small database. It will kill you on a large database.
In the same way, using a grid to select a record works well on a small database. It works poorly when you try to add thousands of lines to the grid.
Think about WHERE a selection will resolve. Hopefully, your server will do your filtering, and return only the records you need. If you do it wrong, you might read all the records across the wan, and try to select records locally on each PC. (Ouch!)
Good luck.