Multiple queries require many logins to same database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Walt Palmer (WaltPalmer02_at_yahoo.com)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 08:32:09 -0700

I have several Excel workbooks that use Access as their
data source (Access is linked to SQL server). Each
workbooks uses a number of the Access queries to get its
data; Excel forces me to login to SQL Server for each
query, even though they are all through the same Access
database.

Is there way to override this behavior? Can't I login
once and refresh all of my queries with a single database
login?

TIA.

Relevant Pages

  • Starting with VB2005 and SQL Server 2008 Express Edition
    ... Writing a VB application to connect to SQL Server 2008 Express to handle the data entry instead of using Access. ... However I'm finding it difficult to try out SQL Server 2008 Express to connect to a database from VB. ... When I click this it opens a window that asks me to choose a data source type. ... The next screen asks me to choose a data connection. ...
    (microsoft.public.vb.database)
  • Re: Access 2003 - ODBC File Data Source - Relink every Access Sess
    ... Click on System DSN, click Add, select SQL Server, click Finish. ... titled "Create a New Data Source to SQL Server." ... "SQL Server Login" pops up, with the Data Source and then the name I called ... "Use Trusted Connection" is unchecked. ...
    (microsoft.public.data.odbc)
  • Re: Populating mail merge doc with data from MSsql 2K table
    ... > the MS Query option in Word - when you get to the Select Data Source ... Enter the name of the Windows computer that is running SQL Server ... Word should now create the .odc file and select it as the data source. ... if you did not sleect Windows Authentication and you did not ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Use of IF then Else syntax in Access
    ... Is this being used in a query? ... this is referring to a field in the query's data source. ... that means using the SQL Server T-SQL syntax, ...
    (microsoft.public.access.queries)
  • Re: Mail Merge office 2003 from SQL Database
    ... Word nowpops up an additional question when you open a mail merge document that is already attached to its data source. ... With WOrd 2000 you would have been using ODBC to connect to SQL Server and you would have had something like ... Field2: Staff Number ... using a selected template (we could end up with several different template ...
    (microsoft.public.word.mailmerge.fields)