I have the following Code, to insert all records of a tablefrom one database to a second database

        Dim sScrDb As String = "C:\CSystems\Data\Main.mdb"
        Dim sConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & sScrDb
        Dim sDstDb As String = "C:\CSystems\Projects\Data\Bck\BackUp.Mdb"
        Dim sSQL As String = "Insert Into Article IN '" & sDstDb & "' Select * From Article "
        Dim mConn As New OleDbConnection(sConn)
        mConn.Open()
        Dim mCom As New OleDbCommand(sSQL, mConn)
        mCom.ExecuteNonQuery()
        mConn.Close()

This is working fine, no problem.
But now I want to put a password on the second database. I can't find how to put this password in theSQL insert intostatement
Can somebody help me.


Best Regards
Vic

I have the following Code, to insert all records of a tablefrom one database to a second database

        Dim sScrDb As String = "C:\CSystems\Data\Main.mdb"

        Dim sConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & sScrDb

        Dim sDstDb As String = "C:\CSystems\Projects\Data\Bck\BackUp.Mdb"

        Dim sSQL As String = "Insert Into Article IN '" & sDstDb & "' Select * From Article "

        Dim mConn As New OleDbConnection(sConn)

        mConn.Open()

        Dim mCom As New OleDbCommand(sSQL, mConn)

        mCom.ExecuteNonQuery()

        mConn.Close()

This is working fine, no problem.
But now I want to put a password on the second database. I can't find how to put this password in theSQL insert intostatement
Can somebody help me.


Best Regards
Vic

dig here please:

http://social.msdn.microsoft.com/Search/en-US?query=insert%20password&ac=3

---

Don't judge me, just Upgrade me. Thanks!

You can use ALTER DATABASE PASSWORD. See the below link for an example:

http://msdn.microsoft.com/en-us/library/aa139977(office.10).aspx#acadvsql_dbpword

---

Paul ~~~~ Microsoft MVP (Visual Basic)