Replies
No one has replied to this post.
Thank you Dan, that is most helpful.
My original helpdesk ticket is CRM:0033031. I'm afraid I got asked so many questions (we must have exchanged over 30 emails), I eventually reluctantly had to give up due to lack of time.
Hoping you have more luck than I did.
Thanks again.
Peter
Hi Peter,
As I normally export to SQL I turned this off to test only using the export to mdb but all work ok excepting that when I opened the mdb in my output directory it automatically had to repair the file
In the FIS Sandbox, Export directory you should find the file ESFA.DC.ILR.DataStore.Database.mdb which should have been copied to your output directory.
I also checked the log file but this showed only that the process had created the mdb in the above directory and then copied it my output directory.
I could not replicate the error you have.
HTH
Don't worry Martin. Dan has replicated it. Did you check which version you were on? Remember it works fine for 20/21 and earlier versions of 19/20.
02:20.2 | INFO | Started export Mdb Process |
02:24.8 | ERROR |
Task Execution Unhandled Failure - Step 8 System.Exception: Export Access process failed with error |
Peter Jones
2019/20 FIS MS Access Export Broken since 1.2.24
Created
I've been having issues with versions of of the FIS after 1.2.24 (2019/20) not exporting Access MDBs:
When you tick 'Export to Access and CSV' in Settings, then import a file, the reports are produced correctly, but as soon as it tries to export the MDB file you get the following error.
I did follow this up with the help desk (including multiple copies of log files) and it is showing as fixed in the known issues. However I have confirmed this with another College.
Does anyone else have this issue?
20/21 works fine.
Many thanks