Querying a Access database as a linked server

From: Aravind (vind74@yahoo.com)
Date: 10/14/02 

From: "Aravind" <vind74@yahoo.com>
Date: Mon, 14 Oct 2002 12:55:08 -0700

Buddy

The query should be like this:

select * from MyAccessDb...MyTable

Aravind

>-----Original Message-----
>I created a linked server to an MS Access database.
However, I don't knwo
>how to query it. You can't use 4-part naming so how do I
slect data from a
>table. Given that my linked server name id "MyAccessDb"
and a table in teh
>database is named "MyTable", how would I select from it?
>
>--Buddy
>
>
>.
>

Relevant Pages

  • ANSI defaults, Linked Server
    ... Access database that our Credit Card processing software uses. ... written a SP to grab some data from this Linked Server, and from my local SQL ... Enable these options and the reissue your query" ...
    (microsoft.public.sqlserver.programming)
  • Re: Linked Server to secure Access Database
    ... Remove the so-called "security" from the Access database. ... capable of doing a google search can easily bypass Jet security, ... >I have created a linked server to a secure database with following query ...
    (microsoft.public.sqlserver.server)
  • Re: Linked Servers - Real Post
    ... The way to query a Linked Server is by means of an OPENQUERY, OPENROWSET, or ... you should be able to query an Access database directly from Access ... > added the linked server I want, and SQL queries it fine, ...
    (microsoft.public.sqlserver.programming)
  • Querying a Access database as a linked server
    ... I created a linked server to an MS Access database. ... how to query it. ... You can't use 4-part naming so how do I slect data from a ...
    (microsoft.public.sqlserver.security)
  • ~~~~~~~~~~~~~ MS ACCESS ~~~~~~~~~~~~~
    ... accdbman ms access database query table ... age bracket ms access report ... buy ms access download full version ...
    (comp.mail.pine)