????? ??? ????? ?????? Microsoft Access ?? ???? ADO

?????? ????????? ?????? ?????????
???? ???????: 230501
????? ???? | ?? ????

?? ??? ??????

??????

??? ????? ?? ??? ?? ???? ??????? ADO ???????? ??? ??? ????? ?????? Microsoft Access? ???? ????? ??? ????????? ???????? ???? ADO: ???? Microsoft Jet OLE DB ??????? ????? ???????? (JRO). ?? ????? ??? ????????? ???? ??? ?? ???? JET OLE DB ??????? 4.0 (Msjetoledb40.dll) ???????? JRO 2.1 (Msjro.dll). ????? ????? DLL ??? ??? ????? MDAC 2.1. ????? ????? ???? ????? MDAC ?? ???? ?????? ??? ?????:
???? ??? ?????? ??? ???????? ???????

??????? ????

???? ????? ?????? Access ???????? ADO? MDAC 2.1 ?? ???? ??? ???? ???? ????? ??? ???? ?????????. ???? ??? ??????? ???????? ???? ????? ?????? Microsoft Access ???????? Visual Basic ? Visual c + +:

Visual Basic: ??? ????? ?????? Access ???? ADO

  1. ?? Visual Basic IDE? ?? ??????? ???????? ? ???? " ?????".
  2. ????? Microsoft Jet ?????? X.X ?????? ????? ????????? ??? (X.X ???? ?? ?? ????? 2, 1).
  3. ????? ???? ????????? ???????? ??????? ??? Visual Basic? ??????? ?????? ????? ???????? ?????? ??????? ??? ??????:
    Dim jro As jro.JetEngine
    Set jro = New jro.JetEngine
    jro.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\nwind2.mdb;Jet OLEDB:Database Password=test", _ 
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\abbc2.mdb;Jet OLEDB:Engine Type=4;Jet OLEDB:Database Password=test"
    					
??????: ?? 3.60 DAO? ????? ????????????? ?? ??? ???????. ????? ??? ????? ??????? ??????? CompactDatabase. ?????? ??? ??????? ????? ????????????? 3.5 DAO.

Visual c + +: ??? ????? ?????? Access ???? ADO

  1. ???????? ??? # import? Msado15.dll (MDAC2.1)? ??? ??????? # import ??????? ????? ???? ?????? ? JRO ????? ??? ??????? ?????? ?? (????? ?? ???? ????? ????? ???? ?????? ???? ????? ???????? ?????? no_implementation ? implementation_only ?? ??????? ??????????? # import):
    #import "C:\PROGRAM FILES\COMMON FILES\System\ado\MSJRO.DLL" no_namespace 
    					
  2. ??? ????? ?????? (????? ?????? ????? ???????? ?????? ??????? ????? ??) ??? ??? ??? ??????? ??? ???? ??? ????? ????????:
    ...
    try
    {
       IJetEnginePtr jet(__uuidof(JetEngine));
      jet->CompactDatabase( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\nwind2.mdb;Jet OLEDB:Database Password=test", 
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\abbc.mdb;" \ 
    "Jet OLEDB:Engine Type=4;Jet OLEDB:Database Password=test");
    }
    catch(_com_error &e) 
    {       
       ::MessageBox(NULL, (LPCTSTR)e.Description( ), "", MB_OK) ;    
    }
    					
??????: ??? OLEDB:Engine Jet = 4 ??? ?? ??? ????? MDB ????? 3.x Jet. ??? ?? ??????? ??? ??????? ??? ????? ????? ???????? ???????? ??? ??????? 4.0 (??? OLEDB:Engine Jet = 5). ???? ?????? ?????? ????? ???????? ???? OLEDB:Engine Jet:
?? ??? ??????????? ??? ??????
??? OLEDB:Engine jetX.x jet ????? MDB ?????
1JET10
2JET11
3JET2X
4JET3X
5JET4X

?????

????? ?? ?????????? ?????? ???? ?? ??? ??????? ?? "????? ??????? ? Microsoft":
230496 ??? ????? ?????? Microsoft Access ?????? OLE DB

???????

???? ???????: 230501 - ????? ??? ??????: 25/????? ???????/1433 - ??????: 1.0
????? ??????: 
kbhowto kbjet kbprovider kbmt KB230501 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????230501
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com