????? ??????? ??????? OpenDatabase ??? ????? ?????? ????? ????? ???? ?? Access 2000

?????? ????????? ?????? ?????????
???? ???????: 209953 - ??? ???????? ???? ????? ????? ??? ???????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

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

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

??????

???? ??? ??????? ????? ??????? ??????? OpenDatabase ???? ????? ?????? Microsoft Access ???? ????? ??? ???? ???? ????? ??????. ???? ?? ??? ??? ?? ??? ????? ?????? ???? ??? ????? ?? ???? ???? ??? ????? ???????? Microsoft Access.

??????? ????

??? ??? ???? ?? ??????? ????? OpenDatabase ???? ????? ?????? ????? ????? ???? ????? ???? ???? ????? ???????? ???? ?? ????? ???????. ???? ???? ???? ????? ?????? ?? ??????? OpenDatabase ??? ???:
????? ????? ?????? = workspace.OpenDatabase (dbname ?? options ? read-only ?? connect)
??????: ??? ?? ?????? ? ??????? ??? ???????? ????? OpenDatabase ???????? ?? ??????? ??? ?????? ???????? ? ??? ????? ??? ??? ??????? ??????? ???????. ??? ??? ?????? ????? ??????? ?? ??? ?????? ?????? ? ??????? ??? ???????? ???? ??? ??? ??????? 3031:
???? ???? ??? ?????.
???? ????? ????? ??? ??? ?? ???? ??? ???? ?????? ???? ??? ???????? ?? ??????? ???????. ??? ?? ??? ????? ??? ??????? ????? ??????? ????? ????? ?????? ? ??????? ??? ????????.

??? ??????? ??????? OpenDatabase ???? ????? ?????? Access ????? ????? ???? ????? ??????? ??????? ????? OpenDatabase ???? ?????? ??????:
MS Access; pwd = password
???????? ????? OpenDatabase ???? ????? ????? ???????? Northwind.mdb (???? ????? ????? ???? ????? ?????? ?? "northwind") ? ???? ??????? ???????:

??????: ??????? ??? ?? ?????? ??? ?????? "Microsoft Data Access ??????. ??? ?? ???? DAO Microsoft ?????? ??? ??? ???????? ???????? ?????? ????? ???? ????? ?????? 3.6. ?????? ????? ???? "?????" ?? ??????? ????? ?? Visual Basic Editor ?? ???? ?? ????? ???? ???????? ????? ?????? Microsoft DAO 3.6.

?????: ??? ???? ??????? ???????? ?? ??? ??????, ????? ????? ????? ????? ???????? Northwind.mdb. ?? ???? ?? ???? ???????? ?? ??? Northwind.mdb ?? ???? ??????? ??????? ??? ???? ?? ????? ????????.

  1. ??? ????? Microsoft Access ?? ??? ??????? ????? ???????? Northwind.mdb ????????? ?????. ?????? ????? ???? ??? ??? ????? ???????? ?? ??????? ??? ???? ??? ????? ??????? ??? ???? ??? ???? ???????? ?? ?? ???? ??? ??? ???.
  2. ?? ??????? ?????? ??? ??? ???? ? ?? ???? ??? ????? ???? ???? ????? ????????.
  3. ???? northwind ?? ???????? ???? ?????? ? ??????.
  4. ???? ??? ????? ?????? ???? ?????? ????? ???? ???? ????? ????????.
  5. ?? ?????? ????? ????????.
  6. ????? ????? ?????? ???? ?????.
  7. ????? ???? ????? ????? ??????? ??????:

    ??????: ?????? ?????? ?????? ??? Northwind.mdb ??? ????? ?????? ????? ?? ?? ????? ????????? ???????? ??????.
    Sub OpenDB()
     Dim db As DAO.Database
     Dim ws As DAO.WorkSpace
     Dim rst As DAO.Recordset
     Set ws = DBEngine.WorkSpaces(0)
     Set db = ws.OpenDatabase _
     ("C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb", _
     False, False, "MS Access;PWD=northwind")
     Set rst = db.OpenRecordset("Customers", dbOpenDynaset)
     If rst.RecordCount > 0 Then
       rst.MoveLast
       MsgBox rst!CustomerID
     End If
     rst.Close
     db.Close
    End Sub
    					
  8. ??????? ??? ??????? ???? ????? ?????? ?? ???? ??????? ?? ???? ????? ??????? ENTER:
    OpenDB
    ???? ?? ???? ????? ???? "???? ??????" ?? ??? ??? ?? ???? "???????" ? ???? ??? ??? ????? ???????? ?????.

?????

?????? ??? ???? ?? ????????? ??? ????? OpenDatabase ???? ??? "??????? Microsoft Visual Basic" ?? ??????? ??????? ? ???? ????? opendatabase ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????.

????? ?? ????????? ??? ????? ???? ????? ???????? ???? ??? ??????? Microsoft Access ?? ??????? ??????? ? ???? ????? ??? ????? ?????? (. mdb) ?????? ??? Microsoft ?? ???? ?????? ?? ??????? ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????? ???? ?? ???????.

???????

???? ???????: 209953 - ????? ??? ??????: 15/?? ?????/1425 - ??????: 3.1
????? ???
  • Microsoft Access 2000 Standard Edition
????? ??????: 
kbmt kbautomation kbpasswords kbdatabase kbopenfile kbhowto kbprogramming KB209953 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????209953

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

 

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