I have a room with several configurations and a family table. When I open the family table, the message "OPEN RECORDSET FAILED" appears. I have to click a few times to make it disappear.
How can we stop having this message every time a family table is opened?
In fact it is due to the use of the wizard for drilling with parts families. There is a known incompatibility (with the 2012 version only?), the bug has been reported to SolidWorks under the number SPR534076.
So no solution! Except maybe an update to SolidWorks...
Source (be logged in to your SolidWorks account for the first link):
Technical Comments:
In some cases changing the local region allows the Excel file to be opened without problem. It is possible that the source ofthis issue is in some way connected to date formatting within the Excel document One of the causes of this error is a generic issue in Foreign language versions of SolidWorks. The error occurs when special characters, such as the diameter symbol, are inserted into the design table. This may happen when a hole wizard parameter value contains a diameter symbol. Try using English version of SolidWorks to see if the issue is still reproducible.