Now it's possible to access data on MSDE with only one user (IIS). I
want to make a web application that gets the data from a MSDE database.
In this mode more then one users can access to the data but in reality
only one user even the IIS have access to the database. Ist this way in
the future of IIS possible, too? Reason the costs i don't want to
install SQL Server.

Thanks

hi,
[quoted text, click to view]

I'm not aware of changes in future releases of the product(s) that prevents
this..
anyway, it's not about "users" you should be concerned, as all MSDE related
"problems" are about concurrent workloads
(http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true)
and even using IIS with the very same user (AKA Login) can be an issue if
and when more then 8 concurrent batches are running..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply