????? ??? ??????? "?" ????? AccessConnection

?????? ????????? ?????? ?????????
???? ???????: 281784 - ??? ???????? ???? ????? ????? ??? ???????.
??????: ????? ????? ?????? ??????? ??????? ???????? ? ?????? ?????? ??????????.

????? ??? ?????? ??? ????? ?????? Microsoft Access (.mdb) ????? Microsoft Access (.adp).

????? ???? | ?? ????

?? ??? ??????

??????

?????? ??? ??????? ?????????? ??? CurrentProject.Connection ?????? CurrentProject.AccessConnection ?? Microsoft Access 2002 ?? ??????? ??????.

??????? ????

?? ????? ??????? CurrentProject.Connection ?? Microsoft Access 2000. ???? ???????? ????? ??? ????? ????????? ???????? ADO ?? Microsoft Access ??????? ADO ??? ????? ??????? ?? ??? Microsoft Access ?????? ???????? ???????? ?????? (Jet ?? ????? ?????? SQL Server). ??? ????? ???????? ?? ???????? ??? ??? ?????? ????????? ADO ????? ????? ????? ??? ??????? ?? ????? ???????? ???????? ?????? ?? Microsoft Access.

?? ????? ??????? CurrentProject.AccessConnection ?? Microsoft Access 2002. ??? ??????? CurrentProject.Connection ???? ???????? ??????? ????? ADO ?? Microsoft Access. ????? ??? ??? ??????? ????? ??? ?? ??? ??? ?????? ????? Access (??? ????? ?????? ???? SQL ? ADP) ?? ??? (MDB) ?? Microsoft Access ????? ???????? Jet.

?????? Access (ADPs)

??? ??????? ????? Access (ADP) ?? Microsoft Access 2002 ?? ??????? ?????? ???? ?? ???? ??? ??? CurrentProject.Connection ?????? CurrentProject.AccessConnection. ????? ??? ????? ????? ADO ?????? ???? OLEDB ???? SQL (SQLOLEDB) ??? ?? ???? ???????? ????? Microsoft Access 10 OLEDB (Microsoft.Access.OLEDB.10.0) ??? ???? ????.

??????: Microsoft Access 10 OLEDB ?????? ?? ???? ???? OLEDB ???? ?? ??????? ???? ??? ????????? ?? Microsoft Access. ?? ??? ????? ?? ??????? ???? ??? Microsoft Access ? ??? ?????? ?? ????????? ??????.

????? ??? ????? ????? ??????? ???? ?? ??????? ?????? ??????? ??? ADP ???? ?????? ?????? ???? SQL:
??????? ???? Provider=Microsoft.Access.OLEDB.10.0;Persist = True; "???? ????????" = MySQLServer; "????? ????????" = <username>; ???? ?????? = < ???? ?????? ?????? > ";" ?????? ??????? "= NorthwindCS; Provider=SQLOLEDB.1 ????????

????? ?????? Jet (MDBs)

??? ??????? ????? ?????? Jet ?? Microsoft Access 2002 ?? ??????? ?????? ?????? CurrentProject.Connection ?????? CurrentProject.AccessConnection ??????? ADO ??????. ????? ??????? ??? ??????? ??? ????? ????????? ???????? ADO ?? ????? ?????? Jet. ??? ???? ???? ??? ??????? ??? ???? ??? ????? ?????. ???? ??? ??????? ?????? ?? ????? ?? ????? ?? Microsoft Access 2002 ?? ??????? ?????? ? ?? ??? ????? ?? ???????? ??? ??????? ??? ???????.

CurrentProject.Connection

???? ??????? CurrentProject.Connection ?????? ??? ??? ?? Microsoft Access 2000. ???? ?????? ????? ADO ???????? ???? Microsoft Jet OLEDB (Microsoft.Jet.OLEDB.4.0 ????). ??? ???? ??????? ?? ????? ????? ??????? ???? ?? ??????? ?? ????? ?????? Jet ???? ???????? ??????? CurrentProject.Connection ???:
???? Provider=Microsoft.Jet.OLEDB.4.0;Data = C:\Program Files\Microsoft Office\Office10\Samples\Northwind.mdb
???? ??? ?????????? ??? ???? ??????? CurrentProject.Connection. ??? ??? ??????? ????? ?? ????? ?? ?? ??????? ??????? ? ??? ???? ??????? CurrentProject.Connection ?????? ????? ADO.
  • ??? Jet "?" ?????? ????? ???????? (JRO).
  • Microsoft ADO ???????? ??????? ?? DDL ???? ?????? (ADOX).
  • ??? ADO ????? ??? ?????? ??????? ??????? ADO ??? ????? ???.
?? ????? ???? Microsoft Access 10 OLEDB ???????? OLEDB ???????? ??????? ???? ??????? ????? ???? ????. ??? ??? ??????? ????? ?? ????? ??? ???????, ??? ???? ??????? ????? ?? ??????? ?????? ???? Jet OLEDB ???? ??? ??????? ?????? ??????? CurrentProject.Connection.

CurrentProject.AccessConnection

????? ??????? CurrentProject.AccessConnection ????? ADO ?????? OLEDB ????? ????????. ?????? ???? Jet OLEDB (Microsoft.Jet.OLEDB.4.0) ???? ???????? "?" ???? Microsoft Access 10 OLEDB ???? (Microsoft.Access.OLEDB.10.0) ????? ????. ??? ???? ??????? ?? ????? ????? ??????? ???? ?? ??????? ?? ????? ?????? Jet ???? ???????? ??????? CurrentProject.Connection ???:
???? Provider=Microsoft.Access.OLEDB.10.0;Data = ???? C:\Program Files\Microsoft Office\Office10\Samples\Northwind.mdb;User = ?????; Provider=Microsoft.Jet.OLEDB.4.0 ????????
???? ???? ?????? ???????? ???????? ??????? CurrentProject.AccessConnection. ???? Microsoft ???????? CurrentProject.AccessConnection ??? ??? ???? ????? ??????? ??????? ADO ???? ??? ????? Access. ???? ???? ?? ???? ??????? ??????? ?? ?? ??? ?????? ???????? ???? OLEDB 10 Access Microsoft ??? ??? ???? ?????? ??????? ??????? ??????? ?? ADO.

?????

?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
281998????? ??? ????? Microsoft Access ??? ??????? ??????? ADO

???????

???? ???????: 281784 - ????? ??? ??????: 04/?????/1424 - ??????: 5.3
????? ???
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbmt kbinfo KB281784 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????281784

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

 

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