How many rows of data can I have in my Access database table before I have to seriously start worrying about awful performance?
I know this topic/question has been floating in the Internet for a number of years. But it seems that the answer is always to walk away from Access into SQL and other platforms. What if walking away from Access is not an option? I am interested to know:
I know this topic/question has been floating in the Internet for a number of years. But it seems that the answer is always to walk away from Access into SQL and other platforms. What if walking away from Access is not an option? I am interested to know:
- How much performance degrading are we talking about? Run a query/report, go make a cup of coffee and 10 minutes later the query/report is complete?
- Will users experience all sorts of problems and weird glitches with the front end?
- What other shenanigans do I have to worry about?