Problem with IN clause

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steven (anonymous_at_discussions.microsoft.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 11:50:04 -0800

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