Re: How do I use Access 2003 with SQL Server Express?

MSDE (I believe the 'E' stands for 'Engine' and not 'Environment') is to SQL
Server 2000 as SQL Server Express Edition is to SQL Server 2005. Because it
is an older version of SQL Server, it is compatible with current versions of
Access. So far as I am aware, I don't think you should have any significant
problems transferring the MSDE database to SQL Server Express for
deployment, though you might want to ask about that in a SQL Server forum.

Obviously, though, you're not going to be able to take advantage of new
features of SQL Server Express that way, so either the VS.NET tools or SQL
Server Management Studio Express might be a better choice for designing SQL
Server Express databases.

I'm not sure which editions of Visual Studio do or do not include the
database designers, or which edition you're using, so I can't be sure
whether you have access to those tools or not. But SQL Server Management
Studio Express is a capable tool, available to anyone, and it's free.

--
Brendan Reynolds
Access MVP

"NGM MS Office" <NGMMSOffice@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F4DF756E-0972-4ACD-B32E-B1DF9ADC6DBA@xxxxxxxxxxxxxxxx

Is MSDE (Microsoft Database Environment) yet another semi-compatible
storage
engine to compete with Access and SQL or is MSDE the name for Access's
database engine?

I'll post a mockup of what I'm looking to create and hopefully that will
make my questions pertaining to the proper tools to use a little easier to
address.

Thanks

-Nathan



.

Relevant Pages

  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: msde2000
    ... Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, ... As for it being better than MS-Access, the answer to that is probable yes, ... MOST other database DO NOT. ...
    (microsoft.public.vc.mfc)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Re: Theres a new Borland Delphi directions survey up
    ... Choosing and Using MSDE 2000 as the Database Engine for Your Application ... The Microsoft SQL Server 2000 Desktop Engine is an alternative ... database engine in Microsoft Access 2002 which enables software developers ...
    (borland.public.delphi.non-technical)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
Loading