Post reply

Unable to Open Access Table

  • October 9, 2006 at 11:59 am

    #67942

    Greetings,

    I am trying to connect to an Access DB (from SQL Server 2000) and display all records in a particular table.  The SQL I am using is below:

    Select a.* FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', '\\server7\users\spage\survey_results.mdb';'';'', Survey_Results) as a

    However, I receive the following error message when I attempt to execute this:

    Server: Msg 7399, Level 16, State 1, Line 1

    OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.

    OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80040e4d:  Authentication failed.].

    Any ideas?  By the way, this Access DB has no user name or password that is required.

    Thanks in advance!

  • October 10, 2006 at 6:54 am

    #664987

    I believe you still need to supply the username 'admin' even though no password is set for the admin user.

  • October 11, 2006 at 8:51 am

    #665242

    Thanks.  That worked.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply