Hello Forum,
I cannot find the source of an occasional failure inserting data into a database. Any thoughts about what the check or change to help resolve this are appreciated. Details are below.
Thanks in advance,
I'm using a Database/ERP worksheet to insert data into a MS Access database with single table. I have populated the database worksheet fields Status, Completed, Error Message, Condition, Select, Insert, Update and Delete with tags. The insert is triggered by toggling the tag in the Insert field. About 90% of the time the insert operation completes as expected: Status = 0. The other 10% of the time, the insert operation ends with an error: Status = -6 (Object reference not set to an instance of an object.).
I have created a work-around for the failure by toggling the insert tag a second time when the first attempt fails. This patch is working for now but, it's not a final solution. The initial insert is caused by user interaction with a button on a screen. The second insert is triggered by the Screen_WhileOpen() function when a failure of the initial insert is detected.
I am using IWS 8.1 SP1 P0 Build 2601.1803.2601.0000
Information for the connection to this database is below:
OLE DB Provider: Microsoft Office 12.0 Access Database Engine OLE DB Provider
User name: Admin
Blank Password: Enabled
Allow saving password: Enabled
Access permissions: Share Deny None
Extended Properties
Jet OLEDB:Compact Without Replica Repair: False
Jet OLEDB:Create System Database: False
Jet OLEDB:Database Locking Mode: 1
Jet OLEDB:Database Password:
Jet OLEDB:Don't Copy Locale on Compact: False
Jet OLEDB:Encrypt Database: False
Jet OLEDB:Engine Type: 0
Jet OLEDB:Global Bulk Transactions: 1
Jet OLEDB:Global Partial Bulk Ops: 2
Jet OLEDB:New Database Password:
Jet OLEDB:Registry Path:
Jet OLEDB:SFP: False
Jet OLEDB:Support Complex Data: False
Jet OLEDB:System database:
Locale Identifier: 1033
Mode: Share Deny None
Password:
Persist Security Info: True
User ID: Admin