Forum Discussion

Charlie8484's avatar
Charlie8484
Copper Contributor
Aug 09, 2022

Bug saving import steps in Access 365

I'm using Access 365 (ver 2207) on Win 10 Pro (ver 10.0.19044).

Odd new behaviour when saving import steps. Last page of Wizard should show something like this:

(from https://support.microsoft.com/en-us/office/save-the-details-of-an-import-or-export-operation-as-a-specification-6b94e183-2b10-4333-a31a-001fe75321b5).

However, when I check "Save import steps" I no longer get the Save As/Description text boxes:

If I click "Save Import" I get this error message: 

Is anyone else getting this? Any idea how to fix?

  • Yes I can replicate this error for both imported Access objects and other imports such as text files.
    However, I can confirm that the import is saved despite the final screen not appearing.

    The same issue occurs when saving exported object tasks

    Sadly there seems to be at least one new bug every month.
    I will report this bug to the Access team and hopefully it will be easily fixed e.g. with a feature gate rollback

    • Charlie8484's avatar
      Charlie8484
      Copper Contributor

      Thank you isladogs. Noted.

      Worrying for business-critical software such as MS Access that this can suddenly break. We were just using it to build a (simple but important) internal subscription management database and 3 weeks off going live. If this had happened in 4 weeks time it would have caused serious, serious problems.

      If this is a common thing with MS Access, would you recommend an alternative, more stable solution (e.g. LibreOffice Base)? 

      • isladogs's avatar
        isladogs
        MVP
        Irritating though the spate of recent bugs have been, most have been fixed very quickly.
        I've already had a reply from MS stating that the cause has been identified and that a fix will be released fairly soon.

        For info, the bug was also present in v2206 but you were the first to mention it. The fact that a fix is in progress already is I think fairly impressive
        In this case, I don't see how the bug would have had very serious problems. As already stated, the import/export is actually saved despite the final screen not appearing.

        Anyway, to reduce your exposure to bugs, you could change from the monthly channel to e.g.semi annual.

        As for alternatives, it depends on what you need from a database.
        In my opinion, none of the alternatives to Access such as Libre Office have anything like the power, range of features and support is unlikely to be as speedy.
        If you only need a very basic database then other options may be suitable. But for anything more complex, I doubt you will find anything to match Access
  • MSFT has fixed the issue. It should roll out to current channel late September or early October. That seems a month too late. I will ask for confirmation.

    Edit: Confirmed.

    • Tom_van_Stiphout's avatar
      Tom_van_Stiphout
      Steel Contributor
      That said: YOU are the one who could have avoided this altogether. It is not a best practice to be on Current Channel for a business that is not living on the bleeding edge. Let others deal with the bugs, and sit pretty on Semi-Annual Enterprise channel.

Resources