Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2014

    Unanswered: retrieve connection handle

    I have an access application that has a file linked to the IBM AS/400. When a report is run I am prompted for my AS/400 logon.
    I would like to know if/how I can retrieve the connection handle of the connection to the AS/400.
    If this is something that can be done, an example in VBA would be helpful.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    I never worked with an application connected to an AS/400 but generally, you can include the credentials for the connection (user name ans password) in the connection string used to open the connection (for AS/400 its: UserID=myUsername;Password=myPassword; ). see: - Forgot that connection string? Get it here!
    Have a nice day!

Posting Permissions

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