VERIFIED SOLUTION i

MapInfo Professional error: The Micorosoft Access database engine could not find the object

Issue


Opening an Excel spreadsheet in MapInfo Professional 11 with a worksheet name that has a space or special character in the name of the Excel worksheet will cause the following error:
Microsoft Access Database Engine: The Microsoft Access database engine could not find the object 'Sheet1$'_xlnm._FilterDatabas'.  Make sure the object exists and that you spell its name and the path name correctly. If 'Sheet1$'_xlnm._filterDatabas' is not a local object, check your network connection or contact the server administrator.
User-added image

Cause

An Excel worksheet name with a space or special characters such as %, #, @, etc..will cause the error.
User-added image
 

Resolution

UPDATED: March 30, 2017
To fix the problem, open each spreadsheet that is not working properly in Excel.
Remove spaces or special characters in the names of any worksheet that have them.
Example: change the worksheet with a space to have none.  Such as, “sheet 1” to “sheet1”.
 
User-added image
 
Then edit the related MapInfo.Tab file in Notepad so that the sheet name space is deleted in the related .tab as well.

- In windows explorer, find the .tab file that has the same name as the spreadsheet. 
- Right-click on the .tab file and choose “Open With.. ”   Select Notepad to open the .tab file. 
-Edit the reference to the “sheet name” that was corrected in Excel and remove the spaces here.
 
In this example, the space is outlined in the screenshot with Red ().
Once the space is removed, save the changes using file>save.
User-added image
Repeat this process for any .Tab/Excel files that are not working or generate the error.  Once they are corrected, all workspaces should open without errors.
 
This bug has not been fixed in MapInfo Professional version.11 or 11.5  At this time, Tech Support does not have a definite date for implementation of a fix or a specific version.
Environment Details