Moving Access database to SharePoint results in tables with empty linked fields RRS feed

  • Question

  • Using Access 2007 and SharePoint 2007.  If there is a better forum to post this question, let me know.  

    I have an Access database with a number of tables where there are linked fields (using the ID field on the target field).  When I use the built-in Access 2007 capablity to move the database to SharePoint, everything seems to move except the columns in Access which are linked end up being empty on the SharePoint.  The lookups in once instance point to the wrong field in the lookup table (Title instead of _ID).

    How to handle?

    --rms www.rmschneider.com
    • Moved by Wayne Fan Monday, February 7, 2011 2:22 AM It's SharePoint 2007 Issue, thanks. (From:SharePoint 2010 - General Questions and Answers)
    • Moved by Mike Walsh FIN Monday, February 7, 2011 9:26 PM not customization (From:SharePoint - Design and Customization (pre-SharePoint 2010))
    Thursday, February 3, 2011 9:13 PM

All replies