Re: Query tables in two access databases with password

Remove the database password. It's totally useless as protection and
only gives you headaches. Anyone interested in your data only has to
do a simple internet search and they're in.

--Mary

On Thu, 8 Sep 2005 08:26:09 -0700, "Nakio"
<Nakio@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I am working with ado with two database, both with password. I am connected
>to database db1 with Ole Db (i open the conection with password)
>
>When I execute this query (it works when there is no password in the
>database):
>
>dim strSql as string
>strSql = "INSERT INTO [Table1] SELECT * From [c:\Test\db2.mdb][Table1]"
>cnn.Execute strSql
>
>an error occurs because dabase db2.mdb has a password.
>
>Do you know how can i do that?
>I dont want to link Table2 in database db1
.

Relevant Pages

  • Re: Copy record with subform
    ... > database is set up, so I can't give you code. ... > Dim strSQL as String ... > Replace TargetTable with the name of the actual table that the subform is ... In the mean time I can be reading Database Design for Mere Mortals ...
    (microsoft.public.access.queries)
  • Catching a textbox data change AfterUpdate or Change
    ... Private Sub txtActualStart_BeforeUpdate ... Dim db As Database ... Dim strSQL As String ... MsgBox "Incorrect or empty start date." ...
    (microsoft.public.access.forms)
  • Re: IN YOUR OPINION
    ... Dim strSql As String ... 'THE strSQL s the path to the new database that wil be written to... ... 'I check what the string is giving and it'sot giving the path, the path 'is in a field called BackPath in the tblBackPath, right now I just get 'the whole select statement. ... It's also saying that the IDNAME line is 'not in the current collection. ...
    (microsoft.public.access.formscoding)
  • Re: Update Record in a seperate Database
    ... Dim strSql As String ... Allen Browne - Microsoft MVP. ... I am trying to update a record in a different database to the current one ...
    (microsoft.public.access.formscoding)
  • Re: Update Record in a seperate Database
    ... Execute the Update query: ... Dim strSql As String ... I am trying to update a record in a different database to the current one ...
    (microsoft.public.access.formscoding)
Loading