Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

vbÖÐDoEventsµÄʹÓÃÎÊÌ⣿

ÎÒÔÚvbÖжÔaccessÊý¾Ý¿â½øÐÐѹËõºÍ±¸·Ýʱ£¬Ê±¼ä±È½Ï³¤£¬ÓÚÊÇÎҾͼÓÁ˸öÀàËÆ½ø¶ÈÌõµÄ¶«Î÷£¨Ò»¸öͼƬÔÚ½ø¶ÈÌõÀï×óÓÒÑ­»·Òƶ¯£©£¬µ«ÊdzÌÐòÔËÐÐʱ£¬½ø¶ÈÌõÀïµÄͼƬ¾Í²»¶¯ÁË£¬¿ÉÄÜÊÇÒª¼Ó¸öDoevents£¬µ«²»ÖªµÀ¼Óµ½ÄÄ£¿¼ÓÁ˼¸¸öµØ·½¶¼²»ÐС£
½ø¶ÈÌõÀïµÄÍ¼Æ¬ÒÆ¶¯ÊÇÓÃtimer¿Ø¼þ¿ØÖƵ쬰´Àí˵Ӧ¸Ã²»Ó°ÏìµÄ£¬Õâ¸öÔõô½â¾ö£¬

ѹËõ±¸·ÝµÄ´úÂ룺
Public Sub CompactJetDatabase(Location As String, Optional BackupOriginal As Boolean = True)
'¹¤³ÌÖÐÒýÓÃMicrosoft DAO 3.6 Object Library

'On Error GoTo CompactErr


Dim strBackupFile As String

Dim strTempFile As String

'¼ì²éÊý¾Ý¿âÎļþÊÇ·ñ´æÔÚ

If Len(Dir(Location)) Then

'Èç¹ûÐèÒª±¸·Ý¾ÍÖ´Ðб¸·Ý

If BackupOriginal = True Then

strBackupFile = App.Path & "\backup.mdb"

If Len(Dir(strBackupFile)) Then Kill strBackupFile

FileCopy Location, strBackupFile


End If


'´´½¨ÁÙʱÎļþÃû

strTempFile = App.Path & "\temp.mdb"

If Len(Dir(strTempFile)) Then Kill strTempFile

'ͨ¹ýDBEngineѹËõÊý¾Ý¿âÎļþ

DBEngine.CompactDatabase Location, strTempFile

'ɾ³ýÔ­À´µÄÊý¾Ý¿âÎļþ


Kill Location

'¿½±´¸Õ¸ÕѹËõ¹ýÁÙʱÊý¾Ý¿âÎļþÖÁÔ­À´Î»ÖÃ

FileCopy strTempFile, Location


'


Ïà¹ØÎÊ´ð£º

¡¾¼±Çó¡¿VBÖÐʹÓÃWScriptµ÷ÓÃÍⲿÃüÁî - VB / »ù´¡Àà

ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£
´úÂëÈçÏ£º
VB code:

Private Function getFile_CMD(filename, filepath) As Bo ......

vb Å£Âð - Web ¿ª·¢ / vbScript

vbÊDz»ÊǺÜÅ£°¡ ÔõôÄÇô¶àµÄ²¡¶¾¶¼ÊÇvb×öµÄ°¡ c#Ðв»ÐУ¿
c#ÔÚXPÔËÐв»ÁË£¬³ý·ÇÈñðÈËÏÈ×°ÉÏ.net.
VBÏà¶ÔÓÚC,C++,ASMµÈµÈ£¬¾ÖÏÞÐÔ´ó¶àÁË¡£

±ðÔÙ˵ʲôÓïÑÔ²»ÈçʲôÓïÑԵϰÁË£¬Ö»ÓÐÄã²»»áÓûòÓÃ×Ų»Ë³ÊÖµÄÓ ......

VBÈçºÎÓÃWinIO´ò×Ö£¿

ÈçÌâ¡£
²»ÓÃAPIÒ²ÄÜʵÏÖ:
http://topic.csdn.net/u/20090503/10/b8bbc710-37e3-4474-a724-ea6fad2e6bc0.html

ʹÓÃAPIÊä³öÎı¾´æÔÚÏÔʾˢÐÂÎÊÌâ,ÐèÔÚReSize»òPaintʼþÖмÓÈë´úÂë.

http://download.csdn.net/ ......

VB ·ÃÎÊÍøÂç¹²Ïí

¸÷λ¸ßÊÖ£¬Ð¡µÜÏëдһ¸ö³ÌÐò£¬¶ÁÈ¡·þÎñÆ÷ÉϵÄÒ»¸ö¹²ÏíÎļþ£¬µ±Õâ¸öÎļþ±»Ð޸ĺ󣬽«´ËÎļþ¿½±´µ½±¾µØ¼ÆËã»ú¸²¸Ç±¾µØÔ­À´µÄÎļþ¡£Çë¸÷λ´óÏÀд¶Î´úÂ룬ºÍ½âÊÍ£¬Ð»Ð»£¡
ÅжÏÎļþ´óС»òÐÞ¸ÄÈÕÆÚ£¬²»Ò»Ñù¾Í¿½±´µ½±¾µØ
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ