无法压缩我的2GB数据库无效参数 [英] Can't compact my 2GB database Invalid Argument

问题描述

运行时我的XP数据库已超过2GB，并出现错误无效参数


我已经尝试删除表然后尝试压缩和修复数据库，但它不会这样做。任何建议，因为我明天需要它。


感谢您的帮助

Chris

解决方案

< blockquote>

运行时我的XP数据库已超过2GB，并出现错误无效参数


我试过删除表然后尝试压缩和修复数据库，但它不会这样做。任何建议，因为我明天需要它。


感谢您的帮助

Chris

你需要紧凑和修理。如果数据库由于某种原因不想这样做，请查看ldb（已锁定）文件是否已打开并将其删除。这假设系统中没有其他用户。


如果这不起作用，请将文件复制到本地硬盘驱动器并尝试在那里进行压缩和修复。然后在创建备份后替换现有文件。


我建议的另一件事是你打开一个新的访问文件并导入所有对象等。

您需要压缩和修复。如果数据库由于某种原因不想这样做，请查看ldb（已锁定）文件是否已打开并将其删除。这假设系统中没有其他用户。


如果这不起作用，请将文件复制到本地硬盘驱动器并尝试在那里进行压缩和修复。然后在创建备份后替换现有文件。


我可以建议的另一件事是你打开一个新的访问文件并导入所有对象等等。

谢谢，

我尝试了但是它没有用。我正在下载我的备份副本，并希望我可以将表导入已恢复的数据库。你知道我怎么能找出数据库各个部分的大小吗？特别是表，代码和查询。我正在考虑将数据库分成2个代码和一个查询，另一个查询数据，并希望看到我得到了什么改进。

Chris

谢谢，

我尝试了但是它没有用。我正在下载我的备份副本，并希望我可以将表导入已恢复的数据库。你知道我怎么能找出数据库各个部分的大小吗？特别是表，代码和查询。我正在考虑将数据库分成两个代码和一个查询和另一个数据，并希望看到我得到了什么改进。

可能不是一个坏主意，但我认为你会发现其他部分与数据相比可以忽略不计。

Hi,

My XP database has exceeded 2GB when running and gives the error "Invalid Argument"

I''ve tried deleting tables then tried to compact and repair the database but it will not do it. Any suggestions as I need it to work tomorrow.

Thanks for the help
Chris

解决方案

Hi,

My XP database has exceeded 2GB when running and gives the error "Invalid Argument"

I''ve tried deleting tables then tried to compact and repair the database but it will not do it. Any suggestions as I need it to work tomorrow.

Thanks for the help
Chris

You need to compact and repair. If the database won''t do this for some reason see if the ldb (locked) file is open and delete it. This assumes no other user is on the system.

If this doesn''t work copy the file to a local hard drive and try to compact and repair it there. Then replace the existing file after creating a backup.

The only other thing I can suggest is that you open a new access file and import all objects, etc.

You need to compact and repair. If the database won''t do this for some reason see if the ldb (locked) file is open and delete it. This assumes no other user is on the system.

If this doesn''t work copy the file to a local hard drive and try to compact and repair it there. Then replace the existing file after creating a backup.

The only other thing I can suggest is that you open a new access file and import all objects, etc.

Thanks,
I tried that but it did not work. I''m downloading my backup copy and hoping that I can import the tables into the restored database. Do you know how I can find out the size of the various sections of the database are? In particular tables, code and queries. I''m looking at spliting the database into 2 code and queries in one and data in the other and want to see what improvement I get.
Chris

Thanks,
I tried that but it did not work. I''m downloading my backup copy and hoping that I can import the tables into the restored database. Do you know how I can find out the size of the various sections of the database are? In particular tables, code and queries. I''m looking at spliting the database into 2 code and queries in one and data in the other and want to see what improvement I get.

Probably not a bad idea, but I think you''ll find the other parts are negligible in comparison to the data.

这篇关于无法压缩我的2GB数据库无效参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！