Deploying MSDE

I am writing an application in VB.Net that includes a database. I could use
either an Access database (MS Jet) or MSDE. I would rather use MSDE because
it has useful features like triggers and complex stored procedures, but I am
worried about deployment.
My users have all kinds of machines, running anything from Windows 98 to
Windows Server 2003. Some may already have MSDE or SQL Server 2000 installed,
most will not. I will use Installshield Express 4 to make the deployment
package. Some users will download the package from my web site, some will
receive CDs.
I am worried that the complexities of deploying to such a wide range of
target machines may be too great and that I should revert to using a Jet
database.
Does anybody have relevant experience? Are there any useful books or
articles that I could read?
Many thanks
Peter
I have been thru a similar situation where I had a VB.NET Apps with MSDE and
Installshield for deployment on all win OS. I dont have any books or articles
for the same but I could do that. Installing MSDE on a m/c where it already
has a MSDE or SQL svr is not an issue as u should install MSDE with a new
unique instancename always.
siaj
"PeterH" wrote:

> I am writing an application in VB.Net that includes a database. I could use
> either an Access database (MS Jet) or MSDE. I would rather use MSDE because
> it has useful features like triggers and complex stored procedures, but I am
> worried about deployment.
> My users have all kinds of machines, running anything from Windows 98 to
> Windows Server 2003. Some may already have MSDE or SQL Server 2000 installed,
> most will not. I will use Installshield Express 4 to make the deployment
> package. Some users will download the package from my web site, some will
> receive CDs.
> I am worried that the complexities of deploying to such a wide range of
> target machines may be too great and that I should revert to using a Jet
> database.
> Does anybody have relevant experience? Are there any useful books or
> articles that I could read?
> Many thanks
> --
> Peter