I have a question about creating data sources using ODBC connections in MS Reporting Services. The database I need to connect to is the front-end Access database. The front-end db has a number to link tables to the back-end db and also other linked dbases. When I attempt to create my data source to the front end I receive error:
ERROR[Microsoft][ODBC Microsoft Access Driver] You do not have necessary permissions to use the '(unknown)' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.
I can establish a data source connection for the back end database with no problem. Is there an issue with creating ODBC Data sources to front-end Access databases in Reporting Services?