Problems running Access database in Report Studio

[agm]

Hello,

I have set up an ODBC connection in Cognos Connection for my datasource that I have set up in Microsoft Access as a link to an Excel spreadsheet.  I have the ODBC connection set up on both my local PC since that is where I am running FM and on the Cognos server. 

I have tested the connection in Cognos Connection and FM and both are successful.  When I publish the package and try to run a report in Report Studio, I get the following message.

UDA-SQL-0107 A general exception has occurred during the operation "prepare". [Microsoft][ODBC Microsoft Access Driver] 'L:\Content\Excel Data\CognosDataDictionary Excel.xls'

I do have my drive mapped to L and that is where the Excel spreadsheet that is reference in Microsoft Access resides.

I am currently using Cognos version 8.1 

Does anyone have any ideas?

Thanks