Microsoft KB Archive Search

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.

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

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 : 537