Re: Linked Server to MS Access DB: Login Mapping Error

From: Mary Chipman (mchip@nomail.please)
Date: 08/27/02 

From: Mary Chipman <mchip@nomail.please>
Date: Tue, 27 Aug 2002 12:59:03 -0400

You should be able to connect without providing security context as
long as the Access database is unsecured and you have full access to
the folder it lives in. Make sure you have service pack 2 for SQLS,
and make sure the Access database is truly unsecured. If you go into
the security dialogs in Access, look for <unknown> as the owner of the
database or any of the tables. If this is the case, then the mdb is
NOT unsecured--it's just missing the system.mdw it was secured with.
If you log on to access using your current system.mdw and import all
of the objects into a new mdb, then you should have no trouble
accessing it as a linked server using the steps you've outlined below.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Tue, 27 Aug 2002 11:43:56 -0400, "Mark Johnson"
<no-reply@nospam.com> wrote:

>I have a linked server connection set up right now in enterprise manager
>called MYDB. It is pointing to an access database stored in
>d:\test\mydb.mdb. The D:\ drive is a local drive on the server, not mapped
>anywhere remote. The access database is not set to require any login
>information to access the data.
>
>In the [security/linked servers] section of Enterprise manager, for this
>linked server, in the "Security" tab, I have the "Be made without using a
>security context" option checked, and I have no usernames or passwords
>listed at the top.
>
>I am trying to access a table called "Customers" with this Query in Query
>Analyzer:
>
>===============================
>SELECT * FROM MYDB...Customers
>===============================
>
>I get this error:
>
>===============================
>Server: Msg 7416, Level 16, State 2, Line 1
>Access to the remote server is denied because no login-mapping exists.
>===============================
>
>Please forgive me if this is a trivial solution. I am rather new to MS SQL
>Server. Thank-you inadvance for your help!
>
>- Mark
>
>

Relevant Pages

  • Re: Do I understand form optimization correctly?
    ... queries on an Access database. ... Access is file based, not server based. ... If you run any query on the table, the entire table is brought down to ...
    (comp.databases.ms-access)
  • Data View Web Part
    ... i have two types of queries in my MS Access database. ... another query is based on a linked table (linked to ... i can view both queries on my WSS site on the server. ... on my local machine, instead of seeing the data in the query based on the ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Do I understand form optimization correctly?
    ... > queries on an Access database. ... Access is file based, not server based. ... and the query is executed. ...
    (comp.databases.ms-access)
  • Pass-Through, Default DSN?
    ... I am converting my companies Access database to SQL ... as a front end to connect to SQL Server. ... Through query so it connects to the ODBC to run the query, ...
    (microsoft.public.access.queries)
  • Re: How to do this?
    ... move the backend tables to the SQL Server and link the sql server tables in ... > typically one things of an Access database as either a relational database ... when you speak of splitting a frontend to an IIS ...
    (microsoft.public.dotnet.framework.aspnet.security)