SQL Database

A

Andrew C

Hi

I am wanting to create a SQL Database. But i dont know
if i can create it on my machine or whether i need
another machine. I have a website that allows me to have
a SQL Database but i dont want to publish it to the web
to start with.

Is there anyway i can use my everyday machine to create
and run a sql database while i design it

Thanks

Andrew
 
R

Roger Carlson

You *can* have a SQL Server instance on your development machine. However,
I have only personally installed it on Windows NT, Windows 2000, or Windows
XP (Note: Only SQL Server *Developer Edtion* will work on XP), so I cannot
say for sure if it works with Win9x or ME.

Another option is to find and install the MSDE engine, which is basically
SQL Server but limited to only 5 connections. An MSDE database can be
easily exported to an actual SQL Server instance when it comes time to
deploy. MSDE comes with Access 2000 version and up. However where it is on
the install differs by version.

--
--Roger Carlson
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
A

Andrew C

Hi

I have windows XP home editon if it can work on that can
you advise me how to set it up. Or tell me where and how
to install MSDE engine.

Thanks

Andrew
 
Top