"In" Query Question

[SSweez]

I am trying to use the below query to access another Access database
that is password protected. When I run the query as-is it says the
passowrd is invalid. How can I incorporate the password into the
below query?? Thanks in advance.

INSERT INTO Titles (Title, Comments) IN 'C:\Documents and Settings
\db1.mdb'
SELECT Titles.Title, Titles.Comments FROM Titles;

 

['69 Camaro]

Hi.

How can I incorporate the password into the
below query??

Try:

INSERT INTO [;DATABASE=C:\Documents and Settings\db1.mdb;PWD=myPswd].Titles
SELECT Titles.Title, Titles.Comments FROM Titles;

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Gary Walter]

I am trying to use the below query to access another Access database
that is password protected. When I run the query as-is it says the
passowrd is invalid. How can I incorporate the password into the
below query?? Thanks in advance.

INSERT INTO Titles (Title, Comments) IN 'C:\Documents and Settings
\db1.mdb'
SELECT Titles.Title, Titles.Comments FROM Titles;

In addition to Gunny's sage help...

INSERT INTO Titles (Title, Comments)
IN '' [MS Access;PWD=fred;DATABASE=C:\Documents and Settings\db1.mdb]
SELECT T.Title, T.Comments FROM Titles AS T;

that's 2 single quotes before "["

change "fred" to your actual password