我的访问问题 [英] my access problem

问题描述

大家好，我叫kamal ..
我有一个访问问题..
删除文件表记录时我只有一个访问数据库，但文件大小没有减少，所以请告诉我任何与sql中的truncate命令一样工作的sql命令...

请，我只需要sql命令(如果有的话).

hello everyone my name is kamal..
i have one access problem..
i have one access database when i delete the file table record but the file size not reduce so please tell me any sql command that work same like truncate command in sql...

please,i need only sql command if any.

推荐答案

如果我正确理解您的要求，则需要访问的压缩功能".

在访问中删除表/数据时，mdb文件的物理大小将不会减小(甚至可能会增加)，因为访问会保留此(或某物)的记录.

检查这些是否可以帮助您:

http://bytes.com/topic/access/answers/189603-compress-access-db [^ ]

http://www.codeproject.com/Messages/3305680/Error-发生-何时-Access-Database-compress.aspx [ ^ ]

If I understand you correctly you need the compacting "feature" of access.

When deleting a table / data in access the physical size of the mdb file will not reduce (it might even increase) because access keeps record of this (or something).

Check if these can help you:

http://bytes.com/topic/access/answers/189603-compress-access-db[^]

http://www.codeproject.com/Messages/3305680/Error-occur-when-Access-Database-compress.aspx[^]

这篇关于我的访问问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！