I'm writing an app for a small construction business. I'm using C# express to develop a SQL 2005 based windows app. There will be 2 - 3 users needing to use this application - sometimes concurrently. I'm probably wrong, but it appears that when you deploy the app, it copies the files to the users windows profile. Is this a limitation to the express edition? The business has a single Windows 2003 server that I was going to have the users access via a terminal services session, to mimic a centralized db solution with a multi-user app. I want to use trusted security, so each users profile would contain a different data set.

I was also hoping to see the db through SSMSE and perform standard DB maintenance and backups, but it looks like the db file is compiled as part of the c# project.

Also, the app will need to have some reporting capabilities. Can I use VWD 2005 Exp to develop these reports and then call them from the C# windows apps?

Are the express versions capable of these requirements?

thanks for your help