+ Reply to Thread
Results 1 to 2 of 2

ADODB Connection String

  1. #1
    Nigel C
    Guest

    ADODB Connection String

    Access 2000 - A am trying to access another Access 2000 database from a
    code module. I have seen examples of the ADODB connection string - to
    connect to an access database however the database that I am connecting
    to has a database password - I get an error message when attempting to
    specify the 'connect' parameter.
    The following is an example...

    Dim cnn As ADODB.Connection
    Dim rs As ADODB.Recordset
    Dim strSQL As String

    Set cnn = New ADODB.Connection
    cnn.Provider = "Microsoft.Jet.OLEDB.4"
    cnn.Open "C:\Schedule Analysis.mdb", "Admin", "MadeUpPassword"

    However the open statement throws up the following error...
    Error Number - "3706"
    Description - "Provider cannot be found. It may not be properly
    installed."

    Any thoughts on what is wrong here?
    Many Thanks.


  2. #2
    Nigel C
    Guest

    Re: ADODB Connection String

    SORRY please ignore this - posted to wrong group !


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1