Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
Private Sub Form_Load()
Dim Date1 As Date, Date2 As Date
cn.ConnectionString = "DBQ=C:\Documents and Settings\Administrator\My Documents\db1.mdb;DefaultDir=" & _
App.Path & ";Driver={Microsoft Access Driver (*.mdb)};" & _
"DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;" & _
"MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;" & _
"Threads=3;UID=ADMIN;UserCommitSync=Yes;PWD=admind1234;"
cn.Open
rs.Open "select * from XianZhi", cn, adOpenForwardOnly, adLockReadOnly
If rs.EOF Then
cn.Execute "insert into XianZhi(Date1) values(#" & Format(Now, "YYYY/MM/DD") & "#)"
Else
Date1 = rs!Date1
Date2 = rs!Date2
If DateDiff("d", Format(Date2, "YYYY/MM/DD"), Format(Now, "YYYY/MM/DD")) < 0 Then
MsgBox "您觉的时间能倒流吗?", vbExclamation
Unload Me
Else
If DateDiff("d", Format(Date1, "YYYY/MM/DD"), Format(Now, "YYYY/MM/DD")) >= 10 Then
MsgBox "软件试用期(10天)已到!", vbExclamation
Unload Me
End If
End If
End If
End Sub
Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
On Error Resume Next
cn.Execute "update XianZhi set Date2 = #" & Format(Now, "YYYY/MM/DD") & "#"
cn.Close
Set cn = Nothing
rs.Close
Set rs = Nothing
End Sub
这是我用的一段代码
On Error GoTo sss
'若文件不存在,则建立文件
Open ("c:\winnt\abc.ini") For Input As #1
'文件存在,则打开文件
Input #1, b '将数值读入变量b
Close #1
If b > 10 Then MsgBox "对不起,您只能使用本软件10次!": End
'提示用户使用次数并退出程序
c = b + 1 '计数器加1
Open ("c:abc.ini") For Output As #3
Print #3, c '将加1后的数值写入文件
Close #3
Exit Sub
sss:
Open ("c:abc.ini") For Output As #2
Print #2, 1 '建立文件,并写入数值1
Close #2
End Sub
这样也能实现使用次数的限定,不知道好不好?