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
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.
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.
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>
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.
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.