The difference is this:
For Access, the Jet drivers operate directly on the database files (.mdb).
This is why you don't need Access on the computer to use MS Access
databases.
For SQL Server and its variations (MSDE, Express, etc), the drivers
communicate via the SQL engine. They do not operate directly against the
database files. Because of this, you actually need some version of SQL
server on the machine to use the database.
So yes, you do need to install SQL Server Express with the app.
Pete
"Greg" <gr*************@yahoo.co.uk> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
From my dark past I seem to remember that when distributing an app that
talked to an access database, the end user did not need to have access
installed on their machine in order for an application to talk to an
access database file - the Jet engine looked after everything.
What is the score with SQL Server Express? Will users need this
installed on their machines? I guess it is possible to write a script
that installs this along with my app but I am wondering if they really
need SQL server express on their machine.
Greg.