fixing compatibility errors (ACCWeb105002 and ACCWeb105016)

[marklove]

good eve!



i want to publish my access 2007 survey application to web. But my problem is my access project has a compatibility error these are ACCWeb105002 and ACCWeb105016. I dont know how to fix these errors.

i will attach my given project and hopefully someone teach me a solution to my problem thanks!

[AlexHedley]

Have you seen the Help page from Microsoft?

http://office.microsoft.com/en-gb/access-help/web-compatibility-check-relationship-and-lookup-errors-HA010379061.aspx

ACCWeb105002
Error text Lookup row sources must be complete SQL statements with one table and table fields specified to be compatible with the Web.

What it means One or both of the following conditions is true:
• The query for the indicated lookup uses more than one table or query as a data source.
• The columns used in the query are not explicitly selected.

What to do Re-create the lookup, making sure that:
• The lookup uses one web compatible table as its data source.

TIP Any table that is not compatible with the web should have created a row in the Web Compatibilty Issues table when you ran the Compatibilty Checker.
• The lookup query specifies each field explicitly (i.e., do not use SELECT *).


ACCWeb105016
Error text Relationships that are not associated with a valid lookup field are incompatible with the Web.

What it means The relationship is not supported by a lookup field, and is therefore not compatible with a web database.

What to do Create a lookup field between the related tables. Use the Lookup Wizard to create the lookup.