TonyE Posted July 17, 2022 Report Share Posted July 17, 2022 Regrettably a Microsoft update has broken scripting functionality that the PE uses to import and export databases. DoCmd.TransferText acImportDelim/acExportDelim Is the command in question when using named Import and Export specifiers. This is not unique to the PE but it is a rarely used feature of Microsoft Access. It is unclear if or when Microsoft will remedy the issue via an update. There are alternatives but I won't be able to crank one out all that quickly as this functionality was an efficient way to remap field names for the .csv files you find in the commondb\res\ folder. To work around the problem, that mapping all has to be recreated in some other fashion which means mapping fields for roughly 40 files (20 imports, 20 exports), some of which have many fields. More to come when I'm next able to work the problem. Thanks to eeustice for reporting the issue. 1 Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 17, 2022 Author Report Share Posted July 17, 2022 Experience of others https://techcommunity.microsoft.com/t5/access/windows-or-office-365-updates-on-7-12-22-introduced-error-with/m-p/3572587 Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 17, 2022 Author Report Share Posted July 17, 2022 Testing uninstall of Windows KB5015807. No difference, problem remains. High confidence that the July 12th Office updates are at the root of this issue. Version 2206 (Build 15330.20246) Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 20, 2022 Author Report Share Posted July 20, 2022 The next PE build replaces the export specifications, allowing exports to work. I'm slowly cranking away on the first import one. Imports will take a lot longer to re-code than the exports did. Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 22, 2022 Author Report Share Posted July 22, 2022 Magazine Import is working. The first one is the most difficult, right... 1 Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 22, 2022 Author Report Share Posted July 22, 2022 (edited) Tested: A1Ship Edited July 28, 2022 by TonyE Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 22, 2022 Author Report Share Posted July 22, 2022 (edited) Tested: A2Sub Edited July 28, 2022 by TonyE Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 23, 2022 Author Report Share Posted July 23, 2022 (edited) Tested: B1Plane Edited July 28, 2022 by TonyE Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 23, 2022 Author Report Share Posted July 23, 2022 (edited) Tested: bsStringsImport Edited July 28, 2022 by TonyE Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 23, 2022 Author Report Share Posted July 23, 2022 (edited) Tested: C1Gun Edited July 28, 2022 by TonyE Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 23, 2022 Author Report Share Posted July 23, 2022 (edited) Tested: D1Missile Edited July 28, 2022 by TonyE Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 23, 2022 Author Report Share Posted July 23, 2022 (edited) Tested: E1ASW Edited July 28, 2022 by TonyE Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 23, 2022 Author Report Share Posted July 23, 2022 (edited) Tested: F1Torp Edited July 28, 2022 by TonyE Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 23, 2022 Author Report Share Posted July 23, 2022 (edited) Tested: G1Ordnance Edited July 28, 2022 by TonyE Quote Link to comment Share on other sites More sharing options...
TonyE Posted July 23, 2022 Author Report Share Posted July 23, 2022 (edited) Tested: G2ECM Edited July 28, 2022 by TonyE 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.