Access Front End option:
I guess I really would like to try Access on the Front End with MSDE on the
back end although I’m very interested in the Terminal Services option. My
hesitation might be my lack of SQL query creation knowledge.

Does either ADP or .mdb tables over a WAN provide a bigger benefit for
remotely updating forms/reports and queries?

If I use Access ADP on the front end with SQL Server on the back end linking
both should be easy. How would I send new forms, queries, etc. to the end
users if I’m connected remotely (via VPN) and they are on the WAN back bone
and I don’t have access to their computers?

Do I create the application in Access, upsize, and somehow declare my front
end to be ADP? Is data encryption handled entirely in the background?

Web based option
If Terminal Services comes with each copy of Windows 2000 (I assume also
with XP) why would I need to worry about a license restriction of 2? Or did
you mean SQL Server 2000? If there is a restriction, is this for 2 total
users or concurrent?

Since our campus uses Microsoft almost exclusively, can SQL Server be used
as a “web service” backend with tools other than Enterprise Manager, Query
Builder, and Terminal Services? Ie Cold Fusion, ASP, etc.?

How much knowledge do I need of SQL to create queries with SQL Server’s
Query Builder?

Thanks,
philr