如何提高MS Access 2007数据库的大小？ [英] How to increase MS Access 2007 database size?

问题描述

我公司开发的Windows应用程序，后端数据库是Access 2007年。我听说，Access 2007中的最大限制为2GB。

I developed a windows application, back end DB is Access 2007. I heard that max limit of Access 2007 is 2GB.

现在我的问题是，有没有什么办法来增加超出限制的大小？如何创建多个DB中一个应用程序，以增加尺寸和性能？

Now my question is, is there any way to increase the size beyond that limit? How to create more than one db for a application to increase size and performance?

推荐答案

您可以分割你的数据到一个或多个额外的数据库文件，然后从主应用程序数据库中创建链接到卫星表。

You can partition your data into one or more additional database files, then create links to the satellite tables from your main application database.

虽然这种策略可以让你使用存储在访问数据超过2 GB，这不是一个很好的选择。其中一个缺陷是，你不能强制执行不同的数据库文件表之间的参照完整性;单凭该事实可以使分区的非首发于多种应用。

Although that strategy could allow you to use more than 2 GB of data stored in Access, it is not a great choice. One pitfall is that you can't enforce referential integrity between tables in different db files; that fact alone could make partitioning a non-starter for many applications.

另一个问题是临时工作空间。当数据库引擎需要工作空间的磁盘文件，它使用一个临时文件。并且临时文件也被限制为一个最大的2 GB的。所以，如果你有6 GB的数据S $ P $垫的每个1.5 GB 4 DB文件之间，而你需要做的一些东西，需要超过2 GB数据的工作，你可以得到一个错误信息抱怨缺乏磁盘空间。这并不意味着磁盘已满;这意味着所需的临时工作空间大于2 GB。

Another issue is temporary work space. When the db engine needs a disk file for work space, it uses a temporary file. And that temporary file is also restricted to a max of 2 GB. So if you have 6 GB of data spread between 4 db files of 1.5 GB each, and you need to do something which requires working with more than 2 GB of that data, you could get an error message complaining about lack of disk space. It doesn't mean the disk is full; it means the required temporary work space is greater than 2 GB.

在过去已经真正做到了分区有一次，我不想永远做一遍。问访问管理这么多的数据仅仅是不合理的;我不得不花了太多的时间等待它做几乎任何我问。这是更好的来卸载的工作提高到一个更强大的数据库系统。因此，这不仅是一个问题的总存储容量，而且还如何存储数据库可以处理大型数据集。您访问的应用程序可以成为一个客户一个客户端 - 服务器数据库。

Having actually done that partitioning once in the past, I don't want to ever do it again. Asking Access to manage that much data is just unreasonable; I had to spend way too much time waiting on it to do nearly anything I asked. It's much better to off-load that work to a more capable database system. So it's not only an issue of total storage capacity, but also how well the storage database can cope with large data sets. Your Access application could become a client to a client-server database.

我也想你应该仔细研究你存储的东西。例如，有些人喜欢储存的图像。我不。相反，我保存的路径，图像文件。相同的其他文件类型。也许你会发现你可以生活在没有存储BLOB，可以减少你的数据库的大小舒服低于2 GB的限制，并继续访问作为存储。

I also think you should critically examine what you're storing. For example, some folks like to store images. I don't. Instead I store the path to an image file. Same for other file types. Perhaps you might find you can live without storing BLOBs, you can reduce your db size comfortably below the 2 GB limit, and continue with Access as storage.

这篇关于如何提高MS Access 2007数据库的大小？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！