Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖÐÔõôÑùÔÚ±í¸ñÖÐÐÞ¸Ä×ÖÌ壿 - VB / »ù´¡Àà

±ÈÈç˵ҪÔÚ1±íÖеĵÚÈýÁеڶþÐе¥ÔªÖÐÊäÈë¡°Ò»¶þÈý¡±Ò»Òª´ÖÌåËÎÌå12ºÅ×Ö£¬¶þ ²»Òª´ÖÌå 15ºÅ×Ö ÈýбÌå5ºÅ×Ö
´úÂëÓ¦¸ÃÔõô´ò£¿
LZÖ¸µÄÊǸöʲô±í¸ñ¿Ø¼þÄØ£¬Ã²ËÆÖ»ÄÜÉèÖÃÕû¸ö±íµÄ×ÖÌ壬»òÕßij¼¸Ðлò¼¸ÁУ¬Ã»Óе¥¶ÀÉèÖ ......

ΪʲôÓÃVB¸Ä±ä²»Á˹¤¾ßÀ¸°´Å¤µÄ¿í¶È - VB / ¿Ø¼þ

Ϊʲô¹¤¾ßÀ¸°´Å¤µÄ¿í¶È¸Ä±ä²»ÁË,ÔÚÊôÐÔÀï¸ÄÁËÓÖ±ä³ÉÔ­À´µÄÊýÖµÁË

´óºú×ÓÕæÀ÷º¦£¬»Ø´ð»ù±¾¶¼ÊDZ¬Áϼ¶µÄ
´óºú×ÓÉý¼¶Õæ¿ì°¡£¬Õâ²Å¼¸Ìì¾Í5Ìõ¶Ì¿ãÍâ¼ÓÔÂÅÅÃûµÚÒ»ÁË
ÏëÏëÎÒÕâ5¸ö¶Ì¿ã»ìÁ˲¶à8Äê²ÅµÃµ½µÄ¡£

»Ø¸´ ......

°ïÎҸĸÄÕâVBÌâ - VB / »ù´¡Àà

°ïÎÒ¸Ä¸Ä ÎÒ×ܾõµÃÓÐÎÊÌâ
Type ID
  number As Single
  score As Integer
  name As String * 6
End Type
Dim personl As ID, i%
Private Sub Command1_Click()
 i = 0
&nbs ......

Vb.net Access CrystalReport - .NET¼¼Êõ / VB.NET

µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ