Re: sqlserver and access

From: Toby Herring (therring*_at_*teletrack.com)
Date: 09/30/04 

Date: Thu, 30 Sep 2004 10:15:52 -0400

It would be remotely possible, but prohibitively difficult, to use Query
Analyzer as a front end for an Access database. Especially if you're not an
administrator on the SQL Server.

I detect from the working of your questions/statements that you're not quite
solid on exactly what SQL Server is. Query Analyzer is /NOT/ SQL Server.
Query Analyzer is simply a tool that allows an administrator/developer to
communicate with the SQL Server.

Your "central main database system" is actually a SQL Server. The reason
Query analyzer is used in your office primarily to access that system is
because the only purpose Query Analyzer serves is to access a SQL Server.

What David is talking about is using Access instead of Query Analyzer as a
front-end to communicate with the "central main database system." He's not
talking about using Query Analyzer to read data from your Access database. 

-- 
Toby Herring
MCDBA, MCSD, MCP+SB
Need a Second Life? 
http://secondlife.com/ss/?u=03e0e5b303c234bf08e80ee40119a65e
"Matthew Kramer" <mkramer110@hotmail.com> wrote in message 
news:ODcT3fspEHA.1992@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I'm new to sqlserver - I currently have sql server (query analyzer) in
> the office, though it seems to be used primarily for database work on
> our central main database system and requires a special network
> password.  Is there some way to hook it up to a local application in my
> computer like Access?  How could this be done?  Is this something I
> could do myself, or would I need the help of a network administrator?
>
> Also, if I were to use access without sql server (query analyzer) - do
> you think it makes much of a difference in terms of capability and
> queries.  I have a lot of very intensive work with very large datasets.

Relevant Pages

  • Re: SQL2005 sys tables
    ... Maybe you don't have the SQL Editor toolbar open. ... You can also change the database context by using the USE statement in the ... SQL Server Documentation Team ... I mean in sql2000 query analyzer I can do the select statement against ...
    (microsoft.public.sqlserver.security)
  • Re: limits of SQL Server???
    ... I suspect that the problem has more to do with your method of data access/retrieval/display than with SQL Server. ... Running this statement within Query Analyzer displays the 2155 rows in 0 seconds: ... > Does the data come back quickly from the database? ... > "mickey" wrote in message ...
    (microsoft.public.sqlserver.setup)
  • Re: Correct Deleted Default Database??
    ... >>It is not possible to restore dropped database because ... >>connected over trusted connection users and SQL ... Using Query Analyzer or any other tool try to login ... but SQL Server complains that sa is ...
    (microsoft.public.sqlserver.security)
  • Re: Stupid Question - I think!
    ... I know that the table was not updated because I go to the Query Analyzer on ... update statement shown below does run in the Query Analyzer on the PDA ... (against the CE database) ... "Earl" wrote: ...
    (microsoft.public.sqlserver.ce)
  • Strange SQL Server CE 2.0 Problem
    ... Server CE database that is stored on a flash card inside the device. ... I can't use the SQL CE Query Analyzer -- the device ... selectCommand = new SqlCeCommand(sql, _connection, transaction); ...
    (microsoft.public.dotnet.framework.compactframework)