If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"In" Query Question
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; |
#2
|
|||
|
|||
"In" Query Question
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/ex...ributors2.html for contact info. wrote in message oups.com... 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; |
#3
|
|||
|
|||
"In" Query Question
SSweez wrote: 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 |
Thread Tools | |
Display Modes | |
|
|