[RESOLVED] [2005] OleDB Insert question- source Passoword

[MechEng]

I’m trying to use the Insert command to insert data from a table in one MS ACCESS DB to another MS ACCESS Database. The INSERT command works as long as there is not a password on the source ACCESS database. Is there a way to include the password for the source Database? I am using an OleDB connection.

strSQL = "INSERT INTO tbl_Headerinfo "
strSQL = strSQL & "Select * From  tbl_Headerinfo in " & "'" & StrPath & "\" & SourceFileName & "'"

[redmo]

Check out this link. It should help you with the connection string needed

http://www.connectionstrings.com/

Redmo

[jmcilhinney]

Please don't post the same question twice. One thread per topic and one topic per thread.

http://www.vbforums.com/showthread.php?t=547162

[MechEng]

redmo- this is not a connection string issue...

Connection to the Target database is working. If there is NO password on the Source Database, the INSERT command works. What is needed is a way to include the password for the Source Database in the INSERT statement... or to find out if it can not be done, in which case I need to try something else.

Jm- thanks for looking at the post in the Database section. Is there a way to included the password in the INSERT statement or am I at a dead end?

thanks for your help.

[jmcilhinney]

My guess is that there's some way to include connection details in the SQL code for the remote database, although I can't confirm that as I've never used multiple Access databases like that.