我想用一个asp来读取一个已经被另外一个软件以独占方式打开的mdb文件,网上有朋友告诉我可以把asp的代码写成以只读方式打开mdb文件就可以,但是我不会,请高手帮忙写一个,谢谢
我现在的asp代码为
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from xsck "
myuser=request("myuser")
date1=request("date1")
date2=request("date2")
Dim SearchSQL
If myuser"" Then
SearchSQL = SearchSQL & " and myuser like '%" & myuser & "%'"
End If
If IsDate(date1) Then
SearchSQL = SearchSQL & " and Datediff('d','" & date1 & "',sdate) > -1"
End If
If IsDate(date2) Then
SearchSQL = SearchSQL & " and Datediff('d','" & date2 & "',sdate) < 1"
End If
sql="select * from xsckwhere 1=1" & SearchSQL & " order by id desc,id desc"
rs.open sql,conn,1
|