Cannot Read or Write into Data Base – Run-time error 91 - Object variable or with block variable not
Legacy KB ID: 4458
Question
Why can’t I post my POS End of Day data to my Reckon file? I keep getting the error: “Cannot Read or Write into Data Base Run-time error 91 - Object variable or with block variable not set”
Answer
You will experience this error if the information held by POS regarding inputs to a transaction (for example, customer details) is different to the information held by Reckon Accounts due largely to corruption in either files or both.
Both files need to be rebuilt.
Detailed Instructions
- Close POS Terminal and Administrator
- Verify that both POS Terminal and POS Administrator are using the same POS database file (QBPOS.PDB)
- In Windows Explorer, go to: C:\Users\Public\Documents\Reckon\PointOfSale.
- Right click on PointOfSale.ini and open it with Notepad.
- Under [AdminDatabase] check the database path.
The default path is "DatabasePath=C:\Reckon\Point of Sale Professional Administrator\QBPOS.PDB"
- Under [TerminalDatabase] check the database path.
The default path is "DatabasePath=C:\Reckon\Point of Sale Professional Administrator\QBPOS.PDB"
These must be the same. If they are different, determine which is correct and change the other to the same path in this file - Save and close the file.
- Rebuild and then verify your QuickBooks company file. If any errors are found correct them.
- Open POS Administrator and compact and Repair the database file.
- Post the End of Day File to your company file.
Additional Note
This problem may occur on any version of Point of Sale.
Need more help?
Ask the Reckon Community at: https://community.reckon.com/categories/reckonaccounts
Or Log a Support Ticket: https://www.reckon.com/au/support/