Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

No records are returned when you run a query after you disconnect from the network in Access 2010


View products that this article applies to.

Symptoms

Consider the following scenario in Microsoft Access 2010:
  • You publish a new database that contains a table with a text field to a SharePoint server that is running Access Services.
  • You disconnect from the network and then add several records to the table.

    Note In this situation, there are several records with an ID of less than 0.
  • You create a new Web query to return records whose ID is less than 0.
In this scenario, no records are returned when you run the query.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: KB981300, kbprb, kbsurveynew, kbtshoot, kbexpertiseinter

↑ Back to the top

Article Info
Article ID : 981300
Revision : 3
Created on : 5/13/2010
Published on : 5/13/2010
Exists online : False
Views : 399