Jet Replacement?

[Frankie]

I've been out of the MS Access loop for a while and have heard that Jet
(.mdb) is no longer being developed by Microsoft and has in fact been
replaced by ???

What has replaced Jet?

My intention is to have a [small] database that supports an ASP.NET Web
site. I do not want to use SQL Server Express, as I don't want to have to
install and run the database as a "service" (and I think that is necessary
with SS Express). I want to simply copy a [database] file to a directory on
the Web server and then access that database via ADO.NET.

Thanks.

 

[Douglas J. Steele]

The Access Development team was able to get complete control over DAO, and
created a new version (referred to as ACE) for Access 2007. Access 2007
introduced a new file format (.ACCDB, or .ACCDE), but you can still use the
old .MDB (or .MDE) file format with Access 2007: you just can't use the new
features.

If you go with the ACCDB format, see
http://www.connectionstrings.com/?carrier=access2007

 

[Albert D. Kallal]

Jet is still alive and well.

however, MS does have a stand alone, non server, and non service version of
sql.

It basically functions like JET, but is NOT multi-user, does not run as a
service.

I also believe it does not have triggers, or stored procedures.

So, wile jet is alive and well, you can use a 100% compatible sql server
engine that is essentially the same idea as jet, and does not need an
install (it is single user however).

More on this "compact" version of sql can be found here:

http://www.microsoft.com/sql/editions/default.mspx

However, jet is still alive and kicking....