Art,
You can just use MS Access 2000's interface to hit SQL
Server 2000. You may need to download a patch from
Microsoft because there were some changes going from
SQL Server 7.0 to 2000. (URL below). It is definitely
the best way for folks who are used to MS Access to
work with a SQL Server. The interface is very
similar, but there are "extra" features such as a tab
for stored proceedures, and instead of QUERIES its
called VIEWS. There are times you will still need the
enterprise manager, but for most stuff MS Access works
fine. To get started open MS Access 2000 and choose
FILE>NEW PROJECT>Existing Database and point it at
your SQL Server.
Eron
The URL:
http://officeupdate.microsoft.com/2000/downloaddetails/accsql.htm?FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D26675%26redirect%3Dno
-----Original Message-----
From: Art Broussard
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 2:51 PM
To: CF-Talk
Subject: OT: SQL Server 2000
I have a web site that has SQL Server 2000 on it. I
have never even thought of touching this database
until now. I want to go in and create some tables. I
was told I can install some application on my computer
that will allow me to connect to the SQL Sever. Then
use this program to create the tables I need.
Does anyone know what I'm talking about because I sure
don't : ]
TIA
Art
"Never put your finger where you wouldn't put your
nose."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
