BUG: ????? ???? ????? ??? "???? ??? ????? ?? ???" ??? ??? ?????? ??? ????? ???????? ?? "????? ?????? ??? ????????" ??????? ??? ????

?????? ????????? ?????? ?????????
???? ???????: 282380 - ??? ???????? ???? ????? ????? ??? ???????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

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

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

?? ??? ??????

???????

??? ??????? "????? ????? ?????" ????? ????? ?????? Microsoft Access ???? ????? ??? ????? ?????? ??? ???????? ??? ????? Access ?? ????? ????? ????? ???????:
??? ????? UT_HandleADPDataPages ???? ?? 52

?????

???? ?? ???? ??? ?????? ??? ????? ?????? ??? ???????? ???????? ???????? ???? ???? ??? ??? //:http ?? ftp: / / ? ?? https://. ????? ????? ????? ?? ???? ???? ????? ??? ???????? ????? ???? ?????? ????? ????.

????

??????? ?????? ??? ??? ??????? ?????? ???? ????? ???????.

??????? 1: ???????? Re-create

????? ????? ?????????? ??? ????? ?????? ??? ???????? ???????? ??? ????? ????? Access ????.

??????? 2: ??????? ????????? ???????? VBA

?????? Microsoft ???????? Visual Basic for Applications (VBA) ?????? ????? ????? ?? ??? ??? ?????????? ???? ???? ?????? "????? ????? ?????".

??????: ???? ????? ????????? ???????? ??? ????? ?????? ??? ???????? ????????. ?? ???????? ????? ??? ???????? ??????? ?????? ?? ??? ????? ??? ????????? ????????.

?????? ??? ??????? ???? ?????? ????????? ???????? ?? VBA ? ???? ??????? ???????:

???? Microsoft ??????? ???????? ??? ??? ?? ???? ??????? ?? ?? ?????. ??? ????? ???? ?? ????? ??? ???????? ??????? ?????? ???????? ?? ???????? ???? ????. ????? ??? ??????? ???? ?????? ?? ??? ??????? ???? ??? ????? ?? ??????? ???? ??? ????????? ?????? ?????? ?????????. ???? ??????? ????? ??? Microsoft ??? ????? ????? ???? ???? ?? ?????? ?????? ??? ??????? ?????? ????? ?????? ?? ????? ??????? ?????? ??????? ?????.
  1. ???? ??? ???? ??????? ??????? ?? ????? Access ?? ?????? ?????? ?? ???? ??? ????.
  2. ???? ?? ???? ???????? ???????? ??????? ?? "???? Visual Basic:
    Sub RelinkDataPages(strPathToMDBFile As String)
    
        ' Automates Access to create a new data access page in the
        ' project file (.adp) from the links in the database (.mdb) file
        Dim ao As AccessObject
        Dim dp As DataAccessPage
        
        Dim objAccApp As Access.Application
        Set objAccApp = New Access.Application
        
        With objAccApp
            ' open the original MDB file
            .OpenCurrentDatabase strPathToMDBFile
            For Each ao In .CurrentProject.AllDataAccessPages
                
                ' Create the new path with the link from the existing page
                Set dp = Application.CreateDataAccessPage(ao.FullName, False)
                
                ' Modify the connection of the page to match the ADP's connection info.
                ' Using the .Connection or .AccessConnection property includes the
                ' Microsoft.Access.OLEDB.10.0 provider and will not work in the connection
                ' string of a data access page.  As a result, use the .BaseConnectionString
                ' property instead to get the basic information.
    
                ' If you are using SQL Server security, you will need to
                ' to concatenate the user name and password information
                ' for the page.
                dp.MSODSC.ConnectionString = CurrentProject.BaseConnectionString
                
                ' save the new page
                DoCmd.Save acDataAccessPage, dp.Name
                
                ' close the page
                DoCmd.Close acDataAccessPage, dp.Name
                
            Next
        End With
        
        ' cleanup
        Set ao = Nothing
        objAccApp.Quit
        Set objAccApp = Nothing
        
        MsgBox "Pages have been relinked"
    End Sub
    					
  3. ??? ?????? ??????? FixLinks.
  4. ???? ????? ?????? ?? ?????? ?????? ?? ???? ????? ??????? ENTER
    RelinkDataPages "<FullPathToDatabase>"
    					
    ??? <fullpathtodatabase>?? ?????? ??? ????? ???????? ???? ??? ????? ???.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????.

??????? ????

??? ??????? "????? ????? ?????" ????? Access ??? ??? ????? ?????? ??? ????? Access ???????? ?? ????? ???????? ??? ???????? ???????? ?? ????? ????. ?????? ?????? ?????? ???????? ?? ???????? ??? ????? ??? ??????? ???? ??? ????? ????????. ??????? ?? ???? ??????? ??????? ??? ???? ????? ??? ???? ?????? ????? ?? ???? ???? ??????? ?? ??? ???? ??? ? ?????? ????? ?? ???? ???????? ?????? ??? HTTP ?? HTTPS ?? FTP.

????? ??? ??? ?????? ?????? ????? ????? ????? "?????? ??? ??? ?????????? ??? ??? ????? ???????? ?????????:
  • ??? ?????? ??? ??????? ??? ???? ??????? ??? ?????? ?? ??? ???? ?????.

    ????? ???? ??? ?? ?????? ????? ??? ???????? ??????.

    - ? -
  • ???????? ???? ???????; ??? ??????? ?? ?? ??? ??? ?? ??? ?? ????? ??????.
?????????? ?????? ??? ??? ???????? ?????? ????? ????? ????? ??????? ?? ??? "???????" ?? ??? ??????? ??? ????? ????? ????????. ???? ????? ????? ??? ???? ???????? ??? ???? ??? ??? ???? ?????. ?? ??? ??????? ?? ????? ????? ?????? ?? ?????????? ??? ????? ????? ????????.

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

  1. ??? ????? Access ?????? ????? ?????? ????? ?????.
  2. ??????? ???? ???????? ?? ??????? ????? ???????? Northwind.mdb.
  3. ????? ???? ????? ????? ??? ?????? Employees ????? ????? ?????? ??? ???? ??????.
  4. ?? ??????? ?????? ??? ??? ????? ?????? ?????? ???????? ? ?? ???? ??? ????? ????? ?????.
  5. ???? ????????? ?????????? ?? "????? ????? ?????" ?? ??? ??????? Microsoft SQL Server ???? ???? ?????? "????? ????? ??????".

    ???? ??? ??? ??? "????? ????? ?????" ?? ??? ??????? ? ???? ???? ???? ???? ?? ???? ??? ???????? ???? ????? ????? ??????? ?? ??? "???????" ?? ??? ???????.
  6. ???? ??? "?????" ?? ????? ????? (?? ???????) ?? ?? ?????? "????? ????? ?????" ???????.
  7. ???? ??? ???? ????? ?? ?????? "????? ??????" ? ?? ????? ?? ?????? ???? ???? ??? ???????? ?? ??? ??? ??? ????? Access ??? ?? ?????.

???????

???? ???????: 282380 - ????? ??? ??????: 18/?????/1427 - ??????: 4.3
????? ???
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbmt kbwizard kbdap kbtshoot kbbug kberrmsg kbnofix KB282380 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????282380

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

 

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