[RESOLVED] [2005] OleDB Insert question- source Passoword
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.
Code:
strSQL = "INSERT INTO tbl_Headerinfo "
strSQL = strSQL & "Select * From tbl_Headerinfo in " & "'" & StrPath & "\" & SourceFileName & "'"
Re: [2005] OleDB Insert question- source Passoword
Check out this link. It should help you with the connection string needed
http://www.connectionstrings.com/
Redmo
Re: [2005] OleDB Insert question- source Passoword
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
Re: [2005] OleDB Insert question- source Passoword
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.
Re: [2005] OleDB Insert question- source Passoword
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.