Building database with MSDE 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JTART2 (anonymous_at_discussions.microsoft.com)
Date: 11/09/04


Date: Tue, 9 Nov 2004 15:57:59 -0800

I am familiar with MS Access and SQL Server 2000 because
I have set them up myself,and used them in my offices.
(Access front end, SQL Server back end)

I recently purchased Visual Studio .Net so that I may
learn how to program. My goal is to build an application
for my profession that I may sell to others like myself.
To keep the price down I need to use MSDE 2000 as the
database engine.

I am new to programming (VB.Net), but I would like to use
MSDE 2000 as a back end database to a VB.Net front end
(like MS Access). This will keep those who purchase my
application from having to install MS Access or SQL
Server 2000.

I've skimmed through Books On Line for SQL 2000, but they
don't go into specifics or give good examples about how
to use MSDE 2000 with a VB.Net front end. Each article
that I read says "for more information, visit...."

I just keep going in circles with BOL!!!

Thanks for any advice, pointers, or comments!

Newbie,
JTART2



Relevant Pages

  • RE: MSDE instance setup question
    ... Why did the instance of MSDE crated all of this extra files (such as ... Aren't the MSDE and SQL server supposed to ... distributed as a part of applications that require a local data store. ... The main component in MSDE 2000, the database engine, provides for the ...
    (microsoft.public.sqlserver.msde)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • 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: Need help & support regarding MBSA 2.1 beta 2
    ... Issue: Local Account Password Test ... Check is skipped on Windows XP Home Edition computers. ... SQL Server and/or MSDE authentication mode is set to Windows ...
    (microsoft.public.security)
  • Need help & support regarding MBSA 2.1 beta 2
    ... Issue: Local Account Password Test ... Check is skipped on Windows XP Home Edition computers. ... SQL Server and/or MSDE authentication mode is set to Windows Only. ...
    (microsoft.public.security)