A family of Microsoft relational database management systems designed for ease of use.
Sadly, there is no solution (yet) . We have a couple workarounds, but 2 years in still no proper fix and not sure if we'll ever get one. You would have thought, erroneously, that such a catastrophic bug would have been priority no. 1 for Microsoft and addressed promptly, yet here we are 2 YEARS and waiting. I'm sorry to say that I've actually started migrating some of my clients away from Access at this point. Things have become too unstable with Office and Access that they can no longer be counted on. It's bug after bug, and no fixes leaving the developer holding the proverbial bag and looking incompetent in the eye of their clients. And then Microsoft wonders why IT departments hate Microsoft Access, seriously !?
I used to track bugs on my blog and have given up because there are so many, that alone would be a fulltime job to do properly.
Sorry about the rant, but just tired of the same old, same old from Microsoft.
Something seriously needs to change internally at Microsoft.
I need coffee. :-)