Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: Change connection of Access Data Project

    Hey all.
    Got an ADP interface to SQL Server that I'm working on. I can change the connection uses the Access menu system, but I want to create a form that allows the user to enter a Server Name, Database Name, Login, and Password, and then changes the existing connection.

    I just CANNOT find this in the Access or VB help systems (which seem to get less helpful with every new feature that is added to them...).

    Anybody done this before?

    Thanks!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Victory!

    DoCmd.RunCommand acCmdConnection

    Score: Developers 1, Microsoft Help System 0.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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