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

Article translations Article translations
Article ID: 981300 - View products that this article applies to.
Expand all | Collapse all


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.


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


Article ID: 981300 - Last Review: September 17, 2011 - Revision: 4.0
  • Microsoft Access 2010
kbexpertiseinter kbtshoot kbsurveynew kbprb KB981300

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from