Re: SQL Server Express: Anybody Using It?

"Lyle Fairfield" <lylefairfield@xxxxxxx> wrote
Then
SQL Server Express with Visual Web Developer
Express is like Jet with Access?


Um, no, not exactly .. bit of a logic error, there.

However, the following three (free) MS products, combined, offer more than
Access/Jet:

Visual Web Developer Express 2005
SQL Server 2005 Express
Visual Basic 2005 Express

- Development for a sever database and desktop database can be done
identically - no need to be concerned about having to upgrade/replace the
desktop app at some point

- The VB.Net language can be used for console, web, and database apps, a
slight improvement over VBScript, VBA, and VB (although VB.Net does not do
Office apps).

- Web development is integral, without ADP or ASP.

- performance of SQL Server vs. Jet - both are so fast on a single desktop,
that it doesn't even matter.

It would take someone who is an expert in both Access/Jet/VBA and
ADO.Net/SQL Server/VB.Net to truly compare the RAD power of both - but I
would say the combination of these three products (all currently free) have
so many strengths, that Access now has serious competition for the first
time for developers who want to work independently and develop great
standalone database products.

The last adverb for that sentence would be "quickly" - but I don't know
about that, and I'm not sure there are enough true experts in both to know.

Disclaimer: All of this is IMHO, is not intended to ignite flames, and is
based on as yet limited fiddling with the above three tools.


--
Darryl Kerkeslager


.

Relevant Pages

  • Re: Access FE with SQL Server BE or .NET FE and SQL Server BE
    ... I have VB 2008 Express, Visual Web Developer 2008 Express, and SQL Server ... queries or SQL Server stored proceedures. ...
    (microsoft.public.access.modulesdaovba)
  • Need Help With Express Edition Tools
    ... I'm using Visual Web Developer 2005 Express Edition and Microsoft SQL ... created using SQL Server 2000 that I'm using in an ASP.NET ... I can open the database just fine and use it in the ...
    (microsoft.public.sqlserver.tools)
  • Re: update a SQL 2005 Express table with an MS Access 2003 table
    ... application using Visual Web Developer 2005 and SQL Server 2005 ... With the upsize feature you will be able to create the database and pass all data. ... A dialog will appear, in which you have to define a custom DSN which point to you SQL Server database: my suggest is to use "SQL Server" driver and not "SQL Native Client", because the last is not well accepted by Access. ...
    (microsoft.public.access.adp.sqlserver)
  • Create local SQL db in ASP app
    ... Here's what I'm trying to do direct from MS (Create a Database) ... Only I have VS 2005 Pro instead of Visual Web Developer. ... Connections to sql server files require sql server express 2005 to function properly. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Web development question
    ... Visual Web Developer. ... The drag and drop is a common feature that you can find in most web ... Solution Explorer, Server Explorer, the Query Designer, ...
    (microsoft.public.vstudio.development)