Hello -
I have an Access 2010 database that has a front end and a back end. Both are located in a shared folder on our server.
I am trying to work through the process of publishing this database to SharePoint 2010.
When I run the Web Compatibility Checker, I get the following errors:
Relationships that are not associated with a valid lookup field are incompatible with the Web.
These errors ( 3 ) are all associated with one query called Q_COMPANYDATA that is based on ODBC-linked tables on our SQL server.
Element Type: Relationship
Element Name: Q_COMPANYDATA.COMP_ID<-->T_ACTIVITIES.COMP_ID
Control Type: Relationship
Control Name: Q_COMPANYDATA.COMP_ID<-->T_ACTIVITIES.COMP_ID
How do I set up a relationship in the back-end to a query that is in the front end?
I tried creating the relationships between the query and the linked tables in the front end.
I also tried moving the query to the back end and setting up the relationships there. Neither option worked.
Thanks for any tips!
Sandra