# Re: About Access97 DataBase

Posted by Fai on August 25, 1999 at 10:17:01:

In Reply to: About Access97 DataBase posted by 大汉堡 on August 24, 1999 at 20:15:56:

: OLEDB Provider:使用Microsoft Jet 3.51 OLE DB的话,将无
: 法连接上,此时必须要用 MicroSoft OLEDB Provider for ODBC Drivers
: 才能连上

本人用这Connection Command:
ConnStr = "Provider=MSDASQL.1;" & _
"DRIVER=Microsoft Access Driver (*.mdb);" & _
"UID=Admin;" & _
"UserCommitSync = Yes;" & _
"Threads = 3;" & _
"SafeTransactions = 0;" & _
"PageTimeout = 5;" & _
"MaxScanRows = 8;" & _
"MaxBufferSize = 512;" & _
"ImplicitCommitSync = Yes;" & _
"FIL=MS Access;" & _
"DriverId = 25;" & _
"DefaultDir=D:\mdb;" & _
"DBQ=D:\ESU.mdb;"
却出现Error:
[Microsoft][ODBC Microsoft Access 97 Driver]
General error unable to open registry key
'SOFTWARE\ODBC\ODBC.INI\(Null)'

小弟已经用了MicroSoft OLEDB Provider for ODBC Drivers
但仍出现Error,我的DataBase的UserName是Admin,而
Password 是"ABCDE",请问应怎样写呢?

Follow Ups:

- Re: About Access97 DataBase 大汉堡 15:05:20 8/25/99 (0)