Results 1 to 7 of 7
  1. #1
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98

    Database Issue when trying to publish in regards to relationships

    I am trying to publish my database to our sharepoint and it tells me the relationships between my tables and the main table have error ACCWeb105016 for all which is: relatationships that are not associated with a web-compatible lookup are incompatible with the web.



    I am not sure I understand what it means because my tables are like this:

    Main: MID YR MTH PROG BUS CONTACT FREQ ST_CD LOB PROD COMM COMM_TYPE

    YR_table: yr_id yr
    mth_table: mth_id mth
    prog: prog_id prog prog_desc
    bus: busid bus bus_desc
    contact: contactID contact phone email
    freq: freqID freq
    state: st_id st_cd
    lob: lob_id lob lob_desc
    prod: prod_id prod prod_desc
    comm: comm_id comm_lvl comm_desc
    communication: commID comm_type comm_desc

    there are other columns distinct to the main table.

    I join yr in yr_table to yr in the main table. this is because the main table is filled in as a data entry form is used to populate data into this table using the data in the tables to allow the user a selection of information. I have built my relationships in Access and now confused as to why I would get this error.

    Do I need to change the relationship from equal to a left join? It does not say one-to-many in the relationship type, it says indeterminate.

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    All tables must have an autonumber field as primary key.

    All look up fields must include the primary key as the bound field.

    This video shows you how to setup the relationships so they go up to SharePoint correctly:
    http://www.youtube.com/playlist?list...5&feature=plcp
    (choose the migrating data video)

  3. #3
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    So another words, my main table I have to have st_id, yr_id, etc etc etc

  4. #4
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    Cant I just say then instead of having a bunch of IDS something like:

    Table=State primary key is st_cd

    It has 1 field that is primary and then st_cd is in the main table? This way I don't need all these ID things????

  5. #5
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    Wait, I guess not. I guess I have to have this auto ID stuff. Wow. This is going to be 1 large main table. But wait, I just changed it so I have an autonumber in each of the tables and then put the st_id etc id's in main table and ran the compatibility checker and it is still saying it does not like my relationships even though now one to many

  6. #6
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    Oh I just don't get it. Why is this not working. I have done all it says.

  7. #7
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    I fixed the problem. I just changed my tables to have an ID. like state table now has st_id are primary autonumber and then I also added the IDs into main table. Redid relationships and then tested again for publishing and passed.

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

Similar Threads

  1. Replies: 1
    Last Post: 06-02-2014, 07:15 AM
  2. Replies: 0
    Last Post: 02-20-2014, 07:20 AM
  3. Relationships/query issue - Help!
    By Chatholo in forum Queries
    Replies: 13
    Last Post: 07-02-2013, 02:31 AM
  4. Replies: 2
    Last Post: 08-12-2012, 07:38 PM
  5. Issue with Relationships
    By Ev0luTioN in forum Database Design
    Replies: 5
    Last Post: 08-06-2010, 11:45 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