Unable to Open Access Table

• Sherwood Page

  SSC Veteran

  Points: 204

  More actions

  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!

• Monte Pix-294031

  Old Hand

  Points: 371

  More actions

  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.

• Sherwood Page

  SSC Veteran

  Points: 204

  More actions

  October 11, 2006 at 8:51 am

  #665242

  Thanks.  That worked.