Ok - so I'm developing an app that will "download" from a SQL SERVER box two or three tables from a large database. Not all rows will go to the PPC - only those that the person is authorized to view (for instance). And not all columns - just those needed to support a mobile-display that I'm going to develop with VS2005 for the PPC.

I've already installed MS SQL CE and have a proof-of-concept app written.

Basic idea - person docks the PPC and runs the mobile-app. It finds no SDF file on the PPC so it creates it.

It needs to be encrypted - which I know I can do when I create the SDF in VS2005 - hopefully that can be done with a "create-on-the-fly" SDF. I'm concerned about how to make sure they use a good password...

At any rate - after the SDF is created the app will download somehow from the network SQL server. Not sure how it's going to authenticate - we use only window authentication - not sure how the PPC will be able to see the SQL box through the USB wire. Are there replication methods that can be used that I'm not aware of??

Once the data is on the PPC the user is able to view it remotely. If the user tries to access the SDF on a future date and cannot load the password successfully we plan on "deleting" the SDF - forcing them to return to the docking station to re-load.

Any opinions or help that can be offered in regard to these ideas - feel free!

Thanks in advance.