Forum Discussion
Moving Away from MS Access
tsgiannis you know, I came here for help and all I've gotten is different responses telling me I either am wrong for wanting to move away from Access, or people telling me I asked the question "wrong". I thought this was supposed to be a support and help community. I'll just take my questions elsewhere. Good day.
Sorry you feel that way! I can assure you that the intent of my reply was indeed to present options and insight. With limited context it is often hard to tell at what phase a questioner may be at in their quest for information.
So, with limited context, questioners get advice that may go well beyond what they are looking for! Kind of like sitting at dinner with cranky grand parent and you ask that one simple question, "Would you like your lemonade refilled?" .... and two hours later, you still don't have the question answered with the specifics you want, but you decide to refill their lemonade anyway as you listened about the days kids made lemonade from hand picked lemons on the corner and ate blueberries right out of the bushes on old man Johnsons farm.
I do hope you are able to address the needs you have. We have found that PowerBI is addressing the role Access used to fill with respect to analysis and reporting. SQL Server has replaced the use of Access as a repository. However, we have not been able to eliminate Access for its other uses, and at this point we likely won't as the sentiment toward Access has changed since we have implemented PowerBI and mandated all data be stored in a SQL Server repository.