Word query to Access won't pull records

[John H W]

Up through 5/24, a report written in Word (gets data on Open) the query works
fine. After 5/24(no records on 5/25) it does not find any records. Verified
that there are 13 records on 5/27 and 4 on 5/28. Also ran the repair function
in Access just in case the index was bad.

The records in Access are there, but the recordset pulled from Access does
not have any record after 5/24. I have verified that the path in the code is
still correct, so it is not looking at an old copy.

Looked at the recordset's recordcount and it has 17 less records than in
Access.

Changed the query string to just pull the records for 5/26 or 5/27 and it
reports no records available (the query does find the records for 5/24).

Any ideas?

John H W

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Sm9obiBIIFc=?=,

Up through 5/24, a report written in Word (gets data on Open) the query works
fine. After 5/24(no records on 5/25) it does not find any records. Verified
that there are 13 records on 5/27 and 4 on 5/28. Also ran the repair function
in Access just in case the index was bad.

The records in Access are there, but the recordset pulled from Access does
not have any record after 5/24. I have verified that the path in the code is
still correct, so it is not looking at an old copy.

Looked at the recordset's recordcount and it has 17 less records than in
Access.

Changed the query string to just pull the records for 5/26 or 5/27 and it
reports no records available (the query does find the records for 5/24).

Any ideas?

Certainly not without more information. Like, the code you're using to connect
to the data and the SQL statement for querying the data set.

Have you tried setting up a query in Access using the same SQL string, to see if
that's successful? How about repairing the database?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail