what is a SQL server

G

Guest

I am using access for the first time now and they ask me to put in a SQL
server I have no idea what that is
 
F

Frank Stone

hi
It is a special Database server which runs SQL(Structured
Query Language) SQL is a computer language developed by
microsoft. The SQL server's primary function (but not
limited to) is to manage Databases that use a front
end/back end set up.
The SQL server would house the database Tables and data
and it might be managed by the IT dept. all other users
would access and/or update the SQL server from remote PCs.
This is all vaque and general info about SQL servers.
Developed as a database server, they have been used in
other ways.
Regards
Frank
 
W

Wanda Mleczek

aviw00 said:
I am using access for the first time now and they ask me to put in a SQL
server I have no idea what that is


You're kidding, right? Perhaps you should confess your ignorance and tell
them you have no idea what they're talking about. Tell them they might as
well ask the pizza delivery boy to set up the database.
 
R

Randy Harris

Frank Stone said:
hi
It is a special Database server which runs SQL(Structured
Query Language) SQL is a computer language developed by
microsoft. The SQL server's primary function (but not
limited to) is to manage Databases that use a front
end/back end set up.
The SQL server would house the database Tables and data
and it might be managed by the IT dept. all other users
would access and/or update the SQL server from remote PCs.
This is all vaque and general info about SQL servers.
Developed as a database server, they have been used in
other ways.
Regards
Frank


A minor quibble. SQL was not developed by Microsoft. SQL is an ISO/ANSI
standard language derived from SEQUEL (Structured English Query Language)
which was created by E.F. Codd, an IBM research fellow, back before
Microsoft was founded. As Frank has indicated, SQL Server is a RDBMS
product produced and marketed by Microsoft.
 
F

Fred Boer

Quibbles are such fun, eh? Here's another one....

I just finished reading a chapter in "Go To", by Steve Lohr, a history of
programming, in which he ascribes the creation of SEQUEL to Don Chamberlin
and Ray Boyce of IBM. Not to minimize the role played by Codd, by the way!
<g>

Cheers!
Fred Boer
 
R

Randy Harris

I could swear that I'd read that Codd outlined SEQUEL in his original paper.
It was further developed in "Project R" at IBM. I can't find anything to
support that, however. Thanks for the correction.

Randy
 
G

George Nicholson

Microsoft Access gives you the option to either create a new Database (which
is 100% Access/Jet) or create a new Project (Access as a user interface
(front end) to an SQL Server data file (back end)).

It sounds like you are trying to "Create a new Project". *Don't* do that if
you aren't using SQL Server. You want to "Create a new Database" (no SQL
Server prompt).

HTH,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top