Question

Invalid Pointer Error when writing to linked table in MS Access?

  • 14 March 2017
  • 1 reply
  • 4 views
R

Hi, I'm trying to write to a linked table in an MS Access database. I'm using FME Desktop 2015, the access database was created with Access 2016, and the table is linked to a SharePoint list. My Access writer in FME is using version 2007 and set to INSERT. When the access table is local (same attribute schema), it works fine, but when the table is linked to the SharePoint list, I get the following Invalid pointer error. Any ideas how I can try troubleshot?

Microsoft Access Writer: Data type `autonumber' of attribute `ID' of feature type `Daily Changes' is not supported for writing. Attribute will be ignored by writer

Microsoft Access Writer: Failed to write attribute `Title' of feature type `Daily Changes'. Provider Error `(-2147467261) Invalid pointer'

A fatal error has occurred. Check the logfile above for details

A fatal error has occurred. Check the logfile above for details

1 reply

owen
Badge +1

Hello. As it is a linked table, you need to use the Sharepoint writer, as the data doesnt reside in the access database. Owen

Reply


Community Stats

28,707
Posts
109,480
Replies
36,553
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.