Results 1 to 2 of 2
  1. #1
    stewegg is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2017
    Posts
    26

    Web Compatibility Errors: ACCWeb102000 & ACCWeb105002

    Hi guys,



    I have a database with four tables that contain ID from other three tables, companies, independent consultants and projects.
    One project would only have one company and one consultant associated to it.
    However, one company could work with multiple consultants and have multiple projects.
    Same for the consultants: one consultant could work on multiple project and for multiple companies.

    Table Setup:
    Projects
    [ID][CompanyID][ConsultantID][ProjectInfo...]

    Companies
    [ID][CompanyInfo....]


    Consultants

    [ID][ConsultantInfo...]

    InfoTable
    [ID][ProjectID][CompanyID][ConsultantID]

    All the IDs in InfoTable are manually entered with correct association to the projects, companies, and consultants.
    All the [ProjectID][CompanyID][ConsultantID] are all link to its related IDs in the Relationship setup.

    I ran the web compatibility check on the database first issue came up as.....
    ACCWeb105016: Relationships that are not associated with a Web-compatible lookup are incompatible with the Web.

    After going through the Office Support Document I then remove all the relationship; create the [ProjectID]using link wizard.

    But now, I got more errors after the web compatibility check and I can't figure out why.
    ACCWeb102000 object name depends on client object object name.
    ACCWeb105002 Lookup row sources must be complete SQL statements with one table and table fields specified to be compatible with the Web.

    ACCWeb105016: Relationships that are not associated with a Web-compatible lookup are incompatible with the Web.

    PLEASE HELP!

    Thank you!

  2. #2
    stewegg is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2017
    Posts
    26
    Problem Solved!
    The reason for all these "Relationships" issues are because of the frontend and backend database.
    The
    InfoTable was created after the database was split with the other three tables.
    It was not created properly (it was created in the frontend).
    I now moved it to the backend and wala! Problem solved.
    You got to love the not so helping and total useless MS office support documentations.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Web Compatibility Issue
    By CindySimmons in forum SharePoint
    Replies: 0
    Last Post: 03-18-2015, 09:15 AM
  2. Replies: 4
    Last Post: 06-21-2014, 05:43 AM
  3. Replies: 1
    Last Post: 04-22-2013, 02:02 PM
  4. Replies: 10
    Last Post: 07-25-2011, 12:07 PM
  5. Compatibility
    By Tony McGuire in forum Queries
    Replies: 1
    Last Post: 06-26-2009, 10:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums