Re: Problem with IN clause

From: John Viescas (JohnV_at_nomail.please)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 17:26:57 -0600

Try this:

sqlUnionQry = "Select * From Vendors
IN '' [MS Access;PWD=pwhistory;DATABASE=C:\History.mdb];" 

-- 
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
"Steven" <anonymous@discussions.microsoft.com> wrote in message
news:b46f01c407a2$0c3542d0$a401280a@phx.gbl...
> I get a message back "Not a valid password".  But I know
> the password is correct.  What is wrong with this sql
> statement.  There must be something structurally incorrect
> with the password portion.
>
> Dim sqlUnionQry As String
> sqlUnionQry = "Select * From Vendors
> IN 'C:\History.mdb' 'PWD=pwhistory';"
> Me.RecordSource = sqlUnionQry
>
>
> Thank you for your help.
>
> Steven
>
>
>

Relevant Pages

  • Re: Converting Select Query to Make Table in Code
    ... Well, a lot of people like "SQL Queries for Mere Mortals", but some consider ... "Running Microsoft Access 2000" ... where "qrySelect" is the name of your Select query. ...
    (microsoft.public.access.queries)
  • Re: reporting revisits from a query
    ... "Running Microsoft Access 2000" ... "SQL Queries for Mere Mortals" ... > FROM TblJobCard INNER JOIN TblLocation ON TblJobCard.LocationNO = ... SELECT JobCards.* ...
    (microsoft.public.access.queries)
  • Re: Union data from two databases
    ... "Running Microsoft Access 2000" ... And if the history database ... >>John Viescas, author ... >>"SQL Queries for Mere Mortals" ...
    (microsoft.public.access.queries)
  • Re: Rounding problem
    ... See "When Access math doesn't add up": ... please post the SQL from your query - maybe there's something in the ... "Running Microsoft Access 2000" ... "SQL Queries for Mere Mortals" ...
    (microsoft.public.access.queries)
  • Re: Cycle Through two Tables
    ... "Running Microsoft Access 2000" ... >>John Viescas, author ... >>"SQL Queries for Mere Mortals" ... >>> richard ...
    (microsoft.public.access.queries)