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
    645
    I have no idea about sharepoint. Are you preparing your own sql statements for the data transactions?

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    4,288
    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. What's happening? Error messages? Where??
    - Use code tags for code/sql. Implement changes in copies of your database.
    Irregardless, ain't no such word as "reoccur".

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