1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Multiple DB + PASSWORDS

Discussion in 'Databases' started by commandos, Dec 27, 2006.

0
  1. #1
    SELECT brands.* INTO brands IN "+backupFileName+" FROM brands

    This is supposed to copy all the records in the brands table into another table also called brands but in a different database .

    The database called backupFileName

    Now the problem is that the backupFileName is password protected, so I can't insert anything in it .

    it's an access database

    I am using ADO

    any solution?

    how can I specifiy the password?
     
    commandos, Dec 27, 2006 IP
  2. druidelder

    druidelder Peon

    Messages:
    285
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Here is an MS article on using ado to insert into a protected jet db. It works as long as you know the password...

    MS article
     
    druidelder, Dec 28, 2006 IP
    commandos likes this.
  3. commandos

    commandos Notable Member

    Messages:
    3,648
    Likes Received:
    329
    Best Answers:
    0
    Trophy Points:
    280
    #3
    10X Man ! it helped a lot .
     
    commandos, Dec 29, 2006 IP
  4. druidelder

    druidelder Peon

    Messages:
    285
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #4
    No problem.
     
    druidelder, Dec 29, 2006 IP