Post reply

Urgent SQL Linked Server Query - Cannot see ms access linked tables.

  • October 18, 2010 at 7:14 am

    #145985

    I have a linked server connection to ms access db from my sql server. I checked the connections and its working fine. There are some linked tables inside ms access in addition to local table. I cannot see those linked tables from sql server.

    Please help me, i am meeting a strict deadline.

  • October 18, 2010 at 11:07 pm

    #1238831

    What is the query that you are using to access the tables in Access database?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • October 19, 2010 at 6:41 am

    #1238998

    If you can't see the tables, it's probably a security issue.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • October 19, 2010 at 6:43 am

    #1239001

    what happens when you ruin this against your linked server?:

    --list all the tables and their names

    EXEC sp_tables_ex MyLinkedServerName

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply