Results 1 to 3 of 3

Error: Could not find field

  1. #1
    jpar39 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1

    Error: Could not find field

    Hello -



    I've seen similar issues posted elsewhere, but none of the solutions have worked for me. I linked a SharePoint list to Access to serve as a UI for updating the list. From the linked table, I created queries to show the information different groups would need to update, then created forms for each group. As far as I could tell, everything seemed to work as expected while the database was on my hard drive. However, when I loaded it to the SharePoint site where I planned to store it for general access, random items started throwing a "Could not find field" error when users would attempt to change them. I checked all the data types and they all seem to be in order. I refreshed the table link and even created an entirely new database. I'm at a loss as to what could be causing this to happen - there doesn't appear to be any real logic behind which records throw the error. Can anyone help? I'm quite new to Access, so I hope this is just something obvious I'm missing.

    Thanks!

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    649
    I have no idea about sharepoint. Are you preparing your own sql statements for the data transactions?
    Patience serves as a protection against wrongs as clothes do against cold.

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    4,438
    When you put an Access table into SP as a list, the data types can get messed up. Check to make sure they are identical.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    So, like, why do you, like, start a sentence with, like, "so"?

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

Similar Threads

  1. Can't find referenced field error
    By Thompyt in forum Programming
    Replies: 7
    Last Post: 09-04-2015, 08:00 AM
  2. Replies: 3
    Last Post: 10-10-2014, 05:29 PM
  3. Replies: 1
    Last Post: 12-01-2012, 11:44 AM
  4. Replies: 12
    Last Post: 09-14-2012, 03:59 PM
  5. Replies: 5
    Last Post: 06-09-2012, 11:37 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
  •  
Tech Forums: Microsoft Office Forums