Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copyfromrecordset failed after install of Office XP SP3
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Install Office Standard XP on Vista. Uninstall Office 2007 Trial? | Excel Discussion (Misc queries) | |||
to install office asst office 2003 | Setting up and Configuration of Excel | |||
repairing office failed Others are working not excel ? | Excel Discussion (Misc queries) | |||
What program do I install to install office 2003 with no prior pro | Excel Discussion (Misc queries) | |||
how do i get the office assistant to install in office 2003? | Excel Discussion (Misc queries) |