Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Question Unanswered: Select query from table in external DB

    I'm trying to make a select query that access a different MS-Access database, but my problem is that the second database is protected with a password and I still haven't found the sintaxis to include the code.
    This is the sql query I have made:

    Select * FROM C:\DataBasesDir\DataBase2.Table

    When I try to execute this query, it returns me an error msg telling me that it's an incorrect password (which is logical, 'cause I'm not passing any)
    Could somebody help me with this, please?

  2. #2
    Join Date
    Feb 2004

    Angry I have the same problem

    I have the same problem and until it is not solved. I used IN clause, but it doesn't help me. Seems to be that tehere is no way how to work around for this problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts