Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to specify password to MAKE TABLE query (97)

    How to specify password to MAKE TABLE query
    I

  2. #2
    New Lounger
    Join Date
    Sep 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to specify password to MAKE TABLE query (97)

    Not really answering your question but why not do it the other way round? Set up a select query containing all the necessary data in your non-passworded db and set a link to it in the passworded db.
    Best I can think of. Hope it helps.

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to specify password to MAKE TABLE query (97)

    Sorry the reason I can

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How to specify password to MAKE TABLE query (97)

    You may have to do this in code. Then you would put the password in the connect string.
    David Grugeon
    Brisbane Australia

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to specify password to MAKE TABLE query (97)

    That

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How to specify password to MAKE TABLE query (97)

    Look up CreateWorkspace in on-line help. You'll need to pass the userid and password like this:

    Set wrkJet = CreateWorkspace("", "userid", "pwd")
    Set db = wrkJet.OpenDatabase(strDBPathAndFile)

    You need to substitute the actual password and username for pwd and userid in the above example.
    Charlotte

Posting Permissions

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