Of course it all depends on the exact requirements etc., but you asked why
not, so I mentioned some possible reasons.

RBS

"MH" wrote in message
...
Installing the .Net framework is trivial.
Yes, there is a 4Gb maximum database size but who is going to fill that if
they are considering using Excel as a db?
I cannot comment on wether SQL Server Express 2005 is as simple as SQLite
to be honest but I use SQL Server at work so I doubt it would be simpler
for me personally to use.
Again, it may not as fast as SQLite but it does have many features and
reading the list of SQL92 features it does not support, I think I'll stick
with SSE.
SS Express is overkill for the OPs requirements but SQLite is not?

It's up to the OP of course, but SQL Server is a more sought-after skill
to have on your CV.

:o)

MH

"RB Smissaert" wrote in message
...
Why not download SQL Server 2005 Express?

Have to install the .Net framework.
4 Gb maximum database size.
Not as simple as SQLite.
Not as fast as SQLite.
Probably overkill for the OP's requirements.

RBS


"MH" wrote in message
...
Why not download SQL Server 2005 Express?

It's free, it is a full relational database that supports very large
datasets, indexes (clustered and non-clustered), views, triggers, stored
procedures, Transact SQL...

MH

"UBER_GEEK" wrote in message
oups.com...
Dont have access to "Access", but could use Excel as a Database. Does
anyone have any sample code they could share, of quering a database
for a entry, or updating a excel database with a record.

Trying to upgrade from shared spreadsheets.