Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Unanswered: ODBC Connections

    I have asked a question similiar to this in the past.

    I found a way to rig it, connecting access to Oracle but now am facing the same problem in SQL SERVER.

    Does anyone know how to automatically connect my access database to SQL Server so I am not prompted for my ODBC password.

    Thanks for any help you can give.

    Rigging is acceptable!!

  2. #2
    Join Date
    Sep 2002
    South Wales

    Lightbulb Try this

    You can re-link tables with code etc. (Sure someone will post this information), but if linking through the access interface, bring each table in 1 at a time and ensure you tick the (very subtle) remember password tick box during this process - works for me!

    Sorry I cant give you the long answer.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Oct 2003
    Provided Answers: 1
    Try something like that

    DoCmd.TransferDatabase acLink, "ODBC-Datenbank", _
    "ODBC;DSN=" & txt_Dsn & ";UID=" & txt_Uid & ";" & _
    "PWD=" & txt_pw & ";LANGUAGE=us_english;" & _
    "DATABASE=" & txt_DB & " ", acTable, txt_DBvorsilbe & glb_aTables(i), glb_aTables(i) & txt_nachSilbe, lOnlyStructure, lSavePassword

    in a For ..... Next Loop

    where [COLOR=blue]
     . glb_aTables is a Global Array holding the Tables' names.
     . Alle Var starting with txt_ are text Boxes on your Form containing values
     . lSavePassword is True or False

Posting Permissions

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