+ Reply to Thread
Results 1 to 2 of 2

multi valued field FROM clause

  1. #1
    Registered User
    Join Date
    09-22-2006
    Posts
    7

    multi valued field FROM clause

    We have an Access database that uses sharepoint tables. We have linked an Excel spreadsheet to the Access query. The Excel sheet refreshes ok on a Window XP, 32 bit, Office 2010 computer. The file does not refresh on a Windows 7, 64 bit, Office 2010 computer. The user receives the following error message.

    Cannot reference a table with a multi valued field using a From clause that refers to another database.

    The fact that one machine works and another one doesn't make me wonder if there is setting that needs to be changed on the Windows 7, 64 bit machine. Any help is greatly appreciated.

    Thanks,
    Jeff

  2. #2
    Registered User
    Join Date
    05-22-2013
    Location
    Andover, KS
    MS-Off Ver
    2010
    Posts
    1

    Re: multi valued field FROM clause

    Did you ever get a resolution to this issue? I am gettinght same sort of message trying to build a query against an Access database but there are no multi-valued fields in the table or database and I'm wondering if it is a bug with Windows 7 64-bit.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1