Results 1 to 5 of 5
  1. #1
    maxmaggot is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ireland
    Posts
    91

    Compatibility issues with db for Sharepoint

    Hi all,
    I have two compatibilty issues with my db before uploading it to sharepoint.

    They are



    ACCWeb105016

    and

    ACCWeb105010

    I've been tinkering with these for days without any success. I'm new to sharepoint and don't really know where to go from here.


    There is potentially one other issue that I won't worry too much about yet but I use word docs for mail merges with this db. Is that an issue on Sharepoint?

    Thanks for your help
    Karl

  2. #2
    maxmaggot is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ireland
    Posts
    91
    Desperate now... Grasping at straws....Is it possible to remove relationships and write vba to accomplish the same thing?

    Or do I add an extra field to each table that is a lookup table. I really don't want to do this because it will break all forms, queries and reports.

    Anyone know a solution. This seems to be a major issue with Access 2010 and Web compatibility.

    Is it present in versions 2013?
    Last edited by maxmaggot; 07-21-2013 at 11:38 AM. Reason: Desperation

  3. #3
    maxmaggot is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ireland
    Posts
    91
    Tried Sharepoint forums. They won't look at it because its an offline issue preventing it from going online.

    Anyone suggest a guru who knows this stuff?

  4. #4
    maxmaggot is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ireland
    Posts
    91
    Just a suggestion for someone that may know more but if I set the related field to a lookup field with 2 columns - a key and a value e.g. 1 - Advertising, 2 - Apartments etc... will it work and will it break forms, reports, etc... Is this the right approach I suppose is the question. It may remove compatibility issues but will it cause further issues. My deadline is Thursday for this.

  5. #5
    maxmaggot is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ireland
    Posts
    91

    Another attempt

    Tried this with no success. Maybe someone can see were I went wrong?

    http://office.microsoft.com/en-001/a...010341606.aspx

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

Similar Threads

  1. web compatibility issues
    By marklove in forum Access
    Replies: 1
    Last Post: 04-18-2013, 07:44 AM
  2. Replies: 2
    Last Post: 02-06-2013, 12:55 AM
  3. Move to SharePoint Site issues
    By Mercator in forum SharePoint
    Replies: 4
    Last Post: 12-27-2012, 05:52 PM
  4. Access compatibility issues?
    By YounesB3 in forum Access
    Replies: 8
    Last Post: 10-02-2012, 03:38 PM
  5. Issues Web Database in Sharepoint
    By abriscoe in forum SharePoint
    Replies: 6
    Last Post: 05-31-2012, 11:03 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