怎么压缩带密码的access2000数据库? 以前我也遇到过相同的问题,参考msdn 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 手边没有啊ctrl c一下吧 Compact Access Database Using ADOVersion Compatibility: Visual Basic 6 Instructions: Copy the declarations and code below and paste directly into your VB project.Declarations:'NoneCode:'**********************************************************'Passing values compactDB module'Sour_path = Source path of existing database.'Dest_Path = Target path ''Note - 'Add Microsoft Jet and Replication Objects X.X library,'where (X.X is greater than or equal to 2.1).'***********************************************************'Jet OLEDB:Engine Type Jet x.x Format MDB Files '********************* ************************' 1 JET10 ' 2 JET11 ' 3 JET2X ' 4 JET3X ' 5 JET4X '**********************************************************Option Explicit Public Function compactDB(ByVal SOUR_path As String, _ ByVal DEST_path As String) As Boolean On Error GoTo Err_compact Private JRO As New JRO.JetEngine' Source and Destination connection path Private DB_sour As String, DB_dest As String DoEvents DB_sour = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _ & SOUR_path DB_dest = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _ & DEST_path & " ;Jet OLEDB:Engine Type=5" JRO.CompactDatabase DB_sour, DB_dest compactDB = True Exit Function Err_compact: compactDB = False MsgBox Err.Description, vbExclamationEnd Function'*************************************************' Usage Module level or form level.'*************************************************' Dim source_path,Target_path as string' source_path=App.Path & "\Nwind.MDB"' Target_path=App.Path & "\CompactNwind.MDB"' If not compactDB(source_path,Target_path) Then' MsgBox "An error occurred while attempt to rename database " _' & vbCrLf & vbCrLf & DBCP_Name, vbExclamation' End If如果数据库带密码的话这样写:DB_sour = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _ & Source_path & " ;Jet OLEDB:Database Password=123" 急救 在一个COMBO中,列出一个数据库字段的全部值,怎么写循环? 求教报表设计器一个问题,查过贴子,好象真没人问过。 VB调用VC写的API,编译成EXE运行正常,在调试环境中却无法调用! vb winsock多连接问题 谁知道哪里下IIS4.0? 任务栏图标问题 mscomm通讯的问题 找你们帮忙来啦~~~ 如何在IE的工具栏上添加按钮 等待:::请问?access数据库里有一表"订单",表里有一字段"日期",数据类型为"日期",怎样实现查找: 高分求购通用刻录机源代码。
ctrl c一下吧
'NoneCode:
'**********************************************************
'Passing values compactDB module
'Sour_path = Source path of existing database.
'Dest_Path = Target path
'
'Note -
'Add Microsoft Jet and Replication Objects X.X library,
'where (X.X is greater than or equal to 2.1).
'***********************************************************
'Jet OLEDB:Engine Type Jet x.x Format MDB Files
'********************* ************************
' 1 JET10
' 2 JET11
' 3 JET2X
' 4 JET3X
' 5 JET4X
'**********************************************************
Option Explicit
Public Function compactDB(ByVal SOUR_path As String, _
ByVal DEST_path As String) As Boolean
On Error GoTo Err_compact
Private JRO As New JRO.JetEngine
' Source and Destination connection path
Private DB_sour As String, DB_dest As String
DoEvents
DB_sour = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& SOUR_path
DB_dest = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& DEST_path & " ;Jet OLEDB:Engine Type=5"
JRO.CompactDatabase DB_sour, DB_dest
compactDB = True
Exit Function
Err_compact:
compactDB = False
MsgBox Err.Description, vbExclamation
End Function
'*************************************************
' Usage Module level or form level.
'*************************************************
' Dim source_path,Target_path as string
' source_path=App.Path & "\Nwind.MDB"
' Target_path=App.Path & "\CompactNwind.MDB"
' If not compactDB(source_path,Target_path) Then
' MsgBox "An error occurred while attempt to rename database " _
' & vbCrLf & vbCrLf & DBCP_Name, vbExclamation
' End If如果数据库带密码的话这样写:
DB_sour = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& Source_path & " ;Jet OLEDB:Database Password=123"