I have a rather strange issue with Access (seems to happen with both
2003 and 2007) and SQL Server. It seems to happen both with Express
(local instance) and Standard over a WAN. The form enables the user
to generate a spreadsheet from select date range. Two things happen
to this user
1. The routine generates a blank spreadsheet even though there is
data for the selected date range (confirmed because the data is
written to a table in SQL server)
2. The routine generates a spreadsheet with the previously selected
date range rather than the currently selected date range. That is,
the user generates a spreadsheet using 1-29 Jan, then selects 1-31
March. The second spreadsheet still has the 1-29 Jan data, even
though the data in the SQL Server table is for 1-31 March.
I was able to replicate the problem only once using the mde in 2003.
While running the routine the form seemed to repaint, all of the data
disappeared from the form listbox and when completed the form had
reverted to the previous dates. But this only happened for me on the
mde once. It happens to this user both using the mdb and the mde).
I verified that he is writing a new spreadsheet each time (not trying
to overwrite the file).
Any ideas for next steps in troubleshooting this problem? Is it
possible that Access is not refre****ng the cache and if so is there
any way to work around this issue?
Thanks
Cheryl
