MS Access 2010:“无法再打开任何数据库". [英] MS Access 2010: "Cannot open any more databases."

问题描述

在使用单个旧版MS Access应用程序时，我遇到了这个奇怪的错误:

While struggling with a single legacy MS Access application I faced this weird error:

Cannot open any more databases.

应用程序广泛使用UNION sql语句.因此，这似乎导致访问量达到2048个打开表的限制.除了摆脱这些工会，还有其他机会吗?

The application makes extensive use of UNION sql statements. So this seems to cause access hitting the limit of 2048 open tables. Any other chance than getting rid of these unions?

推荐答案

在使用链接的外部表时，我遇到了这个问题.之所以达到此限制，是因为不同的查询一遍又一遍地使用了大约10个excel文件.因此，打开表的数量或多或少是查询和表的乘积.

I had this problem when using linked external tables. The limit was reached because about 10 excel files were used by different queries over and over again. So the number of open tables was more or less the product of queries and tables.

我想象使用联合也会使这个问题倍增.

I imagine using unions multiplies this problem as well.

对我来说，解决方案是先将链接的excel表复制到Access本机表中.然后对本机表运行完全相同的查询.

The solution for me was to copy linked excel tables into Access native tables first. Then run the very same queries with the native tables.

这篇关于MS Access 2010:“无法再打开任何数据库".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！