Data Not Imported and Detailed Log Screen Blank on Data Transfer Workbench

This could be your problem when you use Data Transfer Workbench for import some data to SAP Business One. There’s no error, but somehow, you can’t find any imported data on SAP.

First, when you try to click “Import“, there’s an error:

“Current Recordset Does Not Support Updating. This may be a limitation of the provider, or of the selected locktype.” 

And after finish simulation, you can find on Detailed Log screen blank, none of the results appear. And you can’t update the templates you have uploaded.

So, this happen when windows doesn’t authorize or give permissions for DTW to make modification on your hardisk, and it can be solve with following solutions:

 

1. User must has administrator rights, and Run As Administrator when clicking to Data Transfer Workbench’s icon.orYou can look with right click on DTW’s icon, choose Properties > Shortcut (tab) > Advanced > tick Run As Administrator > Choose OK on Advance Properties screen > click Apply > OK
   
2. Try to install or reinstall Microsoft Access Database Engine, based on your microsoft office version. If you using Office 2016, you can download Ms. Access Database engine here

Well, this is how we managed to solve the error, and now we successfully import with Data Transfer Workbench to SAP Business One.

Also read:

• Faster Import with Data Transfer Workbench
• Can’t Upload Data on UDO with Data Transfer Workbench
• Import Business Partner Data from Excel
• Easier Way to Add New Document Numbering
• Update Your Approval Template Without Error