Results 1 to 2 of 2
  1. #1
    SilverSN95 is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009

    Query on a linked table?

    I intend to run queries on data stored/entered into a SharePoint list that will auto-fill forms with similar data fields. To do this I have linked a sharepoint list with access, and I intended to be able to write queries that would extract data into excel and word files.
    The problem is that when I am selecting the linked access table for my query in excel, I get back the message "Cannot access table (tablename)". Is what I am trying to do even possible, or am I going about this wrong.

    Thanks in advance.

  2. #2
    Nem3s1S is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Sounds like permissions issues within SharePoint or Access. Have you checked your permissions on these?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Linked Table Field Validation
    By yuriyl in forum Access
    Replies: 4
    Last Post: 04-20-2009, 01:31 PM
  2. Linked table to sql 2000 db
    By tcroninstl in forum Access
    Replies: 1
    Last Post: 03-23-2009, 07:27 PM
  3. Using Linked Table Manager --Can't get it work
    By cccgsmith in forum Access
    Replies: 6
    Last Post: 03-11-2009, 06:43 AM
  4. Editing a Linked Table
    By amndza in forum Access
    Replies: 2
    Last Post: 01-21-2009, 01:27 PM
  5. Linked Table Manager
    By driccardi in forum Access
    Replies: 4
    Last Post: 02-15-2006, 11:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums