64位访问仍然抛出“大于数据库的最大大小（2GB）”。在尝试导出查询时。 [英] 64 Bit Access still throwing "larger than the maximum size of a database (2GB)" when trying to export query.

问题描述

我正在尝试在5个不同的表上运行一个构建ID字段的报告，以比较每个建筑物ID的违规次数，每个表都有超过100K的记录，当我尝试导出甚至打开我得到的报告时错误查询无法完成，查询结果的大小
大于数据库的最大大小（2GB）错误，我更新到64位Access 2013，我仍然得到这个，我们知道为什么吗？

I am trying to run a report on 5 different tables building ID fields to compare number of violations on each building ID, each table has well over 100K records, when I try to export or even open the report I get the error The query cannot be completed, either the size of the query result is large than the maximum size of database (2GB) error, I update to the 64bit Access 2013 and am still getting this, do we know why?

推荐答案

当前是什么你的数据库的大小？你最近压缩了吗？拆分它会给前端留出更多空间吗？

What is the current size of your DB? Have you compacted it lately? Does splitting it give you more room in the front end?

Access会抓取缓冲区来运行查询。当发生这种情况时，它可能确实超过了2 G限制。

Access does grab a buffer to run queries. Maybe it really is exceeding the 2 G limit when that happens.

这篇关于64位访问仍然抛出“大于数据库的最大大小（2GB）”。在尝试导出查询时。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！