I'm trying to access some MS Access data within SQL Query Analyzer using OPENROWSET. I don't want to use a User/Password but don't know how to go about it.

I tried:
    SELECT a.*
      FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
      '\\ServerName\ShareName\Nwind.mdb';'admin';'', Orders)
      AS a
but got an error message that I need permission to view the data.

Is there a way I can use "Persist Security Info=False" with OPENROWSET? I tried playing around with it but couldn't get it to work.

TIA.

Rita

May be because you are trying to access from an mdb file on remote system. Can you check that from local system, if that works?

_________________________
-Vijay G
Strive for Perfection

Also you can take a look at this page, this should give you better idea.

http://support.microsoft.com/default...b;EN-US;306269

_________________________
-Vijay G
Strive for Perfection

Vijay,

Thanks so much for your help. Your first tip helped me resolve the issue. I had not mentioned that I was having problems when trying to read the Access file that I had copied on the C: drive.
I had copied it to the C: drive of my pc, not the c: drive of the server where I was connected to via SQL Query Analyzer.

Once I made a copy there, I got the results I was looking for.

Rita