Results 1 to 2 of 2
  1. #1
    rickk16 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    1

    Field will not be moved issue

    I am trying to link the back end of my database to SharePoint, but I am getting the error "Certain fields (like 'binary' fields and SharePoint 'read-only' fields) cannot be migrated." The field being affected is called "Created By," and it is a number field with a row source connecting an employee ID to their name. A column for it is created in SharePoint, but it cannot be edited and it changed all the employee IDs in the Created By field to 9 in Access. What is causing this issue? Also, I get multiple "Field values will not be auto-generated" errors, would Access still enforce autonumbering while creating records in the desktop app? If not would I have to use data macros as a workaround?

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    9,217
    I don't use sharepoint but this comment

    it is a number field with a row source connecting an employee ID to their name.
    implies the field is read only so this

    "Certain fields (like 'binary' fields and SharePoint 'read-only' fields) cannot be migrated."
    will apply

    this

    it changed all the employee IDs in the Created By field to 9 in Access.
    suggests to me that since it is calculated it is applied to all records. Does 9 have any significance to you? such as the ID of the employee of the first record?

    would Access still enforce autonumbering while creating records in the desktop app?
    No - autonumber is a factor of the back end and you are not using the access backend (jet or ace) you are using sharepoint - so that would be something you would need to look to sharepoint to enforce

    If not would I have to use data macros as a workaround?
    don't know, I doubt an access macro would work and as previously said, I don't use sharepoint but perhaps that has a macro or some sort of rule to maintain the list

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

Similar Threads

  1. Choice Field Being Moved to End of Table
    By Kevin51 in forum SharePoint
    Replies: 4
    Last Post: 06-27-2017, 08:01 AM
  2. SQL in Moved Data
    By reynier09 in forum Access
    Replies: 6
    Last Post: 07-22-2016, 06:49 AM
  3. Replies: 22
    Last Post: 05-21-2013, 07:54 PM
  4. Window can't be moved
    By PoorCadaver in forum Access
    Replies: 1
    Last Post: 12-20-2011, 09:55 AM

Tags for this Thread

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