Problems with linked server

I have a view in SQLDB A that is built out of a linked server that points at
an Access (mdb) database.
The linked database is set that security should make connections 'without
using a security context'.
This works perfectly for user sa. If I select from the view I get data.
If I use another SQL authenticated user and make the same select I get:
Server: Msg 7416, Level 16, State 2, Procedure uvTYarDuty, Line 2
Access to the remote server is denied because no login-mapping exists.
Why? As I said the linked server is set to use no authentication which is
supposed to work perfectly for mdb databases...so why cant the non-sa user
read the linked database?
needless to say they have select permissions on the view itself.
This is driving me crazy ;)
Al Blake, Canberra, AustraliaActually, no authentication is not really suppose to work
perfectly. Under the covers, Access uses a user of Admin
with no password if you haven't secured the database. So
that's actually what you are suppose to use.
See books online topic: OLE DB Provider for Jet
So you'll probably want to try using Admin for the user and
a blank password as the example in the help topic explains.
-Sue
On Tue, 15 Mar 2005 10:32:30 +1100, "Al Blake"
<al@._delete_this_.blakes.net> wrote:

>I have a view in SQLDB A that is built out of a linked server that points a
t
>an Access (mdb) database.
>The linked database is set that security should make connections 'without
>using a security context'.
>This works perfectly for user sa. If I select from the view I get data.
>If I use another SQL authenticated user and make the same select I get:
>Server: Msg 7416, Level 16, State 2, Procedure uvTYarDuty, Line 2
>Access to the remote server is denied because no login-mapping exists.
>Why? As I said the linked server is set to use no authentication which is
>supposed to work perfectly for mdb databases...so why cant the non-sa user
>read the linked database?
>needless to say they have select permissions on the view itself.
>This is driving me crazy ;)
>Al Blake, Canberra, Australia
>|||Thanks Sue,
User of admin with a blank password for all 'unknown' users in the linked
server definitions fixed it for me.
Regards
Al.