mdb后缀改成了asp 运行时报错-2147217900 FROM 子句语法错误。代码如下Public Const JetOLEDB = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source="
cnnSYS.Open JetOLEDB & sysPath & "\DATA\sys.asp"
Set cmdSYS.ActiveConnection = cnnSYS
cmdSYS.CommandText = "SELECT * from User"
rstSYS.CursorLocation = adUseClient
rstSYS.Open cmdSYS, , adOpenStatic, adLockBatchOptimistic不知问题在哪
cnnSYS.Open JetOLEDB & sysPath & "\DATA\sys.asp"
Set cmdSYS.ActiveConnection = cnnSYS
cmdSYS.CommandText = "SELECT * from User"
rstSYS.CursorLocation = adUseClient
rstSYS.Open cmdSYS, , adOpenStatic, adLockBatchOptimistic不知问题在哪
cmdSYS.CommandText = "SELECT * from [User]"