????? ??? ????? ?????? Microsoft Access ???????? Visual Basic .NET

?????? ????????? ?????? ?????????
???? ???????: 306287 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

??? ???? ?????? ?????? ActiveX (ADO) ??? .NET ADO ????? ??? ?? ????? ????? ?????? Microsoft Access. ??? ???? ????? ????? ??? ?????? ???????? Microsoft ???? Jet OLE DB ????? ???????? ?????? (JRO) ???? ?? ??????? ?? Microsoft Data Access Components (MDAC) ??????? 2.1. ???? .NET ADO ??????? ?????? ???????? ???????? ??? COM ???? ???? Interop.

???? ??? ??????? ????? ??? ????? ?????? Access ???????? Visual Basic .NET.


???????

  • Microsoft Visual Basic .NET
  • Microsoft Jet "?" ????? ?????? 2.1 ?? 2.5 2.6 ????? ????????

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

  1. ??? ????? ???? Visual Basic .NET ????.
  2. ?? ???? ?????? ?????? ? ???? ??? ?????? ?????? ??? ?????? ??????? ???? ????? ????.
  3. ?? ???? ?????? ????? ??????? ???? ??? ????? ??????? COM ?? ??? Microsoft Jet ? 2 ?????? ????? ????????. x ?????. ???? ??? "?????" ????? ??? ???????? ???????. ???? ??? ?????.

    ?????? ?? ??? ??????? x ???? ???? ???? ??????? ?????? ???? Microsoft Jet "?" ????? ?????? ????? ????????.
  4. ???? ??? ????? ??? ??? ???? ??????? ?? ??? ?????? ??? ??????? ???????. ???? ??? ??? ?????? ?????. ???? ????? Microsoft ActiveX ?????? ?????? ????? (ADODB) ?????? JRO ??? ??????? ???????.
  5. ?? ???? "?????? ??????" ? ???? ??? ?????? ?????? ??? Module1.vb ?? ???? ??? ??? ????????? ????????.
  6. ???? ???? ????????? ???????? ?? ???? ????????? ????????.
  7. ??? ????????? ???????? ?????? ????? ?? ???? ????????? ????????:
    Module Module1
    
        Sub Main()
    
            Dim jro As JRO.JetEngine
    
            jro = New JRO.JetEngine()
    
            jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\nwind.mdb", _
            "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\NewNwind.mdb;Jet OLEDB:Engine Type=5")
    
            MsgBox("Finished Compacting Database!")
        End Sub
    
    End Module
    					
  8. ????? ?????? ??? ????? .mdb ?????? ??????? ?????? ???????. ???? F5 ?????? ??????? ???????.

    ????? ????? ???????? ???????? ?? ????? Access 2000 (Jet 4.0). ?????? ??? ????? Jet ????? ???? "???????".

pitfalls

???? ????? ?????? ???? ????? ?????? Jet ????? ?????? ????? ??? ??? ????? ????????. ??? ???? ?? ?????? ??? ??? ????? ?????? ??? ????????? ?????? ???????. ??? ????????? ???? ?? ???? ?? ??? ???????? ???? ???? ??????....

?????

?????? ??? ?????? ?? ???????? ??? .NET Framework ???? Interop COM ????:
??? ?????? COM ??? .NET Framework
http://msdn2.microsoft.com/en-us/library/z6tx9dw3(vs.71).aspx
?????? ??? ???? ?? ????????? ??? ??????? ADO JRO ??? ????? ?????? Access ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
230501????? ??? ????? ?????? Microsoft Access ?????? ADO

???????

???? ???????: 306287 - ????? ??? ??????: 29/???? ??????/1428 - ??????: 2.3
????? ???
  • Microsoft Visual Basic .NET 2003 Standard Edition
  • Microsoft Visual Basic .NET 2002 Standard Edition
????? ??????: 
kbmt kbhowtomaster KB306287 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????306287

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

 

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