Q&A

  • 엑세스(MDB) 사용시 msjet40.dll이라는 에러가 발생합니다.
개발환경
Window2000 pro SP4
델파이6 엔터프라이즈 SP3
MS Access-2000(MDB)

ADOConnection으로 연결했습니다.
그런데 런타임시에 자꾸 이게 뜨는데요. ADOQuery.OPEN하면

  Debugger Exception Notification
'Access violation at adress 1B041716 in modul 'msjet40.dll'

MDB 연결은 아래와 같이 했습니다.
ADOConn.ConnectionString:='Provider=Microsoft.jet.OLEDB.4.0;' +
                             'User ID=Admin;' +
                             'Data Source=' + IFilePath + ';' +
                             'Mode=Share Deny None;' +
                             'Extended Properties="";' +
                             'jet OLEDB:System database="";' +
                             'jet OLEDB:Registry Path="";' +
                             'jet OLEDB:Database Password="";' +
                             'jet OLEDB:Engine Type=5;' +
                             'jet OLEDB:Database Locking Mode=1;' +
                             'jet OLEDB:Global Partial Bulk Ops=2;' +
                             'jet OLEDB:Global Bulk Transactions=1;' +
                             'jet OLEDB:New Database Password="";' +
                             'jet OLEDB:Create System Database=False;' +
                             'jet OLEDB:Encrypt Database=False;' +
                             'jet OLEDB:Don''t Copy Locale on Compact=False;' +
                             'jet OLEDB:Compact Without Replica Repair=False;'+
                             'jet OLEDB:SFP=False';
0  COMMENTS