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

???? ?????? ???? ??????
???? ID: 209953 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
Moderate: ??? ??????, ??????, ?? ?????????????? ??????? ?????? ???

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

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

??????

?? ???? ????? ?? ?? ?????? ?????? ?????? ?? ????? ???? ???? ??OpenDatabase??????? ??????? ?? ?? Microsoft Access ??????? ?? ????? ?? ??? ?????? ??? ????? ??? ?? ?? Microsoft Access ??????????-???? ??????? ?????? ?? ??? ???????? ?? ?? ???? ??????? ?? ????? ?? ????? ???

???? ???????

??? ?? ????? ???? ????? ???OpenDatabase??????? ????? ?? ??? ??? ???????-????????, ?????? ?? ?? ??? ?? ??? ??? ??????? ??????? ????????? ??????????.????? ???? ??????? ?? ????? ?? ??? ????????OpenDatabase???? ??????????? ??:
Db ??? workspace.OpenDatabase (=dbname,??????,????-????? ?? ???,??????.)
???:: ??? ????????, ??????-???? ?? ????? ????OpenDatabase???? ???? ??? ??? ??? ???????? ???? ???? ?? ??? ???, ???? ?????? ?????? ?? ????? ??????????.????? ??? ?? ?? ????? ??????????.???? ?? ???? ?????? ??????????, ??????-???? ?? ???????, ??-???? ?????? 3031 ???? ???????:
???? ??? ????? ????????
???? ?? ?????? ????? ?? ??? ??? ???? ??? ?????????????.???? ??? ??? ??? ?? ?? ????? ???? ?? ???????? ???? ??, ?? ????????.?? ???? ??, ?? ?? ?? ???? ??? ?????????, ??????-???? ?? ????????

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

???:: ????? ??? ??? ?? ???? ????? Microsoft ???? ?????? ????????? ??? ?? ????? ?? ??? ?? ??? ?? ??? ?? Microsoft DAO ?????? ?????? 3.6 ???????? ?????????? ??? ???? ?? ???, ????? ??????????????? ????????????? Visual Basic ?????? ???, ?? ????????? ???? ?? ??Microsoft DAO 3.6 ???????? ???????????? ????? ????? ???

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

  1. Microsoft Access ?? ??????? ?? ???? ????? ????? ????? ?? ??? Northwind.mdb ???????? ??? ???? ?? ???, ????? ??????????? ?? ?????????? ???????????? ?? ??? ?? ????? ????????????? ??? ????? ????, ?? ?????? ????????? ???? ?? ??? ???????? ?????.
  2. ????? ????????????? ??,????????? ????-????? ????, ?? ???? ?????????? ??????? ?? ??? ????.
  3. ??????:northwind????? ??????????, ?????? ????????? ????
  4. ????? ????,OK??? ???? ?? ?????????? ??????? ?? ??? ????????? ????? ?? ??????? ?? ??? ?? ..
  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
    ??? ???? ?? ??? ????? ????? ?? ????? ?????? ?????? ID ??? ????????? ???? ?? ?? ??????? ??????????? ???? ?? ????? ?????? ???????

??????

OpenDatabase ???? ?? ???? ??? ???? ??????? ?? ??? ????? ????Microsoft Visual Basic ??????????? ???????????, ??????opendatabase ????Office ????? ?? ????? ????????, ?? ???? ?????????? ?? ??????

??????? ??????? ?? ???? ??? ???? ??????? ?? ??? ????? ????Microsoft Access ???????? ???????????, ????????????? ?? ??????????? ?? ??? microsoft ????? (.mdb) ??????? ????? ?? ?????? ????Office ????? ?? ????? ????????, ?? ???? ???????????? ?? ????? ?? ??? ???? ????

???

???? ID: 209953 - ????? ???????: 17 ??????? 2011 - ??????: 4.0
???? ???? ???? ??:
  • Microsoft Access 2000 Standard Edition
??????: 
kbautomation kbpasswords kbdatabase kbopenfile kbhowto kbprogramming kbmt KB209953 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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