General discussion

  • Creator
  • #2317102

    ODBC & Access 2000


    by wdmeyer ·

    How do I open a ODBC file in a VB module in Access 2000? I am using the following:

    Dim cnn1 As ADODB.Connection
    Dim rst1 As ADODB.Recordset
    Set cnn1 = New ADODB.Connection
    Set rst1 = New ADODB.Recordset
    cnn1.Open “DSN=GP;USERID=lincabc;PASSWORD=xxxxx;”
    rst1.Open “LINC.PROPDB_CUST”, cnn1, adOpenDynamic, adLockReadOnly, adCmdTableDirect

    I am unable to use any fields because BOF & Eof are true.

All Comments

  • Author
    • #3544260

      Reply To: ODBC & Access 2000

      by john_wills ·

      In reply to ODBC & Access 2000

      This isn’t really an answer to your question, and may not be applicable to your situation. Link the ODBC table to your Access database. Address it then as though it were a table local to your database. When the table gts addressed there is an automatic pop-up asking for username and password.

    • #2748147

      Reply To: ODBC & Access 2000

      by wdmeyer ·

      In reply to ODBC & Access 2000

      This question was closed by the author

Viewing 1 reply thread