I'm been using copyfromrecordset to extract information from an access
database. This function has been working well for the past year.
This past week we installed Office XP service pack 3. Now
copyfromrecordset generates a copyfromrecordset failed message. I
tested the same function on a PC that was on sp2 and the function
worked properly as it had in the past.

The problem appears to be related to the size of the data returned to
excel. If I changed the max record parameter to 500 it works. If i
leave it unlimited it generates an error.

Any ideas how to get this to work on SP3? We installed it on all of
our PC's.
Thanks


--- James