跟踪数据库的大小 [英] Keeping track of size of database
问题描述
使用A2000
我正在使用驻留在软盘上的小型数据库来写学校
报告然后可以发送到中央数据库进行电子化
整理。有时数据库已经超过磁盘上的1.38Mb
，这已经将整个数据库崩溃到了一个非可靠的
可恢复状态，如果没有备份则会丢失数据。是否可以访问数据库中作为VB函数的数据库大小
，以便我可以在从记录移动到记录时触发警告，如果数据库是
接近极限？
谢谢
比尔
2004年1月7日13:50:07 -0800 comp.databases.ms-access，
bi ** @ piperb.freeserve.co.uk （比尔）写道：
使用A2000
我使用的是驻留在软盘上的迷你数据库用于写学校的磁盘
报告然后可以发送到中央数据库进行电子整理。有时候数据库已经超过磁盘上的1.38Mb，这已经使整个数据库崩溃到一个可恢复的状态，如果没有备份就会丢失数据。是否可以访问数据库中数据库的大小作为VB函数，这样当数据库接近限制时，我可以在从记录移动到记录时触发警告？
FileLen（CurrentDb.Name）
-
A）bort，R） etry，I）用大锤敲击。
Trevor Best< bouncer @ localhost>写道：
FileLen（CurrentDb.Name）
最好的答案。简洁。
Tony
-
Tony Toews，Microsoft Access MVP
请仅回复在新闻组中，以便其他人可以阅读整个消息主题。
Microsoft Access Links，Hints，Tips&会计系统
http://www.granite.ab.ca /accsmstr.htm
FileLen在文件打开之前给出了文件的大小 - 这不是
海报问的内容对于。 FileLen不包括在打开的会话中添加到
文件的附加字节。海报需要LOF功能。
来自帮助文件---
备注
如果在调用FileLen函数时指定的文件是打开的，则返回的值
表示文件在打开之前的大小。
注意要获得打开文件的长度，请使用LOF函数。
-
PC数据表
您的资源获取Access，Excel的帮助和Word应用程序
re******@pcdatasheet.com
www.pcdatasheet.com
Trevor Best <摇椅@本地>在留言中写道
新闻：4k ******************************** @ 4ax.com ...2004年1月7日13:50:07 -0800 comp.databases.ms-access，
bi ** @ piperb.freeserve.co.uk （比尔）写道：
使用A2000
我使用的是迷你数据库在用于写学校的软盘上报告然后可以发送到中央数据库进行电子整理。有时候数据库已经超过磁盘上的1.38Mb，这已经使整个数据库崩溃到一个可恢复的状态，如果没有备份就会丢失数据。是否可以访问数据库中数据库的大小作为VB函数，这样当数据库接近限制时，我可以在从记录移动到记录时触发警告？
FileLen（CurrentDb.Name）
-
A）bort，R）etry，I）用大锤子冲击。
Using A2000
I am using mini-databases residing on floppy disks for writing school
reports which can then be sent to a central db for electronic
collating. Occasionally the database has grown past the 1.38Mb
possible on disk and this has crashed the whole database into an un
recoverable state, losing data if not backed up. Is there access to
the size of the database within the db as a VB function so that I can
trigger a warning when moving from record to record if the db is
getting near the limit?
Thanks
Bill
On 7 Jan 2004 13:50:07 -0800 in comp.databases.ms-access,
bi**@piperb.freeserve.co.uk (Bill) wrote:
Using A2000
I am using mini-databases residing on floppy disks for writing school
reports which can then be sent to a central db for electronic
collating. Occasionally the database has grown past the 1.38Mb
possible on disk and this has crashed the whole database into an un
recoverable state, losing data if not backed up. Is there access to
the size of the database within the db as a VB function so that I can
trigger a warning when moving from record to record if the db is
getting near the limit?
FileLen(CurrentDb.Name)
--
A)bort, R)etry, I)nfluence with large hammer.
Trevor Best <bouncer@localhost> wrote:
FileLen(CurrentDb.Name)
The best kind of answer. Succinct.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
FileLen gives the size of the file before it was opened - this is not what the
poster asked for. FileLen does not include the additional bytes added to the
file in the open session. The poster needs the LOF function.
From the Help file ---
Remarks
If the specified file is open when the FileLen function is called, the value
returned represents the size of the file immediately before it was opened.
Note To obtain the length of an open file, use the LOF function.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Trevor Best" <bouncer@localhost> wrote in message
news:4k********************************@4ax.com...On 7 Jan 2004 13:50:07 -0800 in comp.databases.ms-access,
bi**@piperb.freeserve.co.uk (Bill) wrote:Using A2000
I am using mini-databases residing on floppy disks for writing school
reports which can then be sent to a central db for electronic
collating. Occasionally the database has grown past the 1.38Mb
possible on disk and this has crashed the whole database into an un
recoverable state, losing data if not backed up. Is there access to
the size of the database within the db as a VB function so that I can
trigger a warning when moving from record to record if the db is
getting near the limit?
FileLen(CurrentDb.Name)
--
A)bort, R)etry, I)nfluence with large hammer.
这篇关于跟踪数据库的大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
