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
|kbexpertiseinter kbtshoot kbsurveynew kbprb KB981300|