MSDE has a limitation to 5 simultaneous connections (users). You won't have problem upgarding from MSDE to SQL because MSDE is SQL less some features. The proof of this is that the same service packs applies to both MSDE and SQL.
>I have a database to build in SQL Server, about 6 to 8 users to start. Can I start with MSDE and migrate to SQL Server in a few months? Will I come across any limitations or road blocks?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com