ACC2000: ?? ???? ?? ???? ???? SQL ????? ????? ?? ???? ?? ????? ????? ??????

?????? ????????? ?????? ?????????
???? ???????: 251289 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

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

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

?? ??? ??????

???????

??? ????? ??? ???? ??? ???? ?????? Microsoft SQL Server ????? ?? ???????? ??? ??? ?????? ?? ????? ??? ??????? ???????:
??? ??? ??????? TAB ???????? ??? ????? ?????? ?????? ??? ????? ?? ??? ?? ??? ???? ?? ???? ????? ???? ??? ??????? ???? disappears.When ???? ??? ???? ???? ?? ???? ?? ?? ???? ??? ??? ????? ? ????? ???? ????? disappears.When ???? ??? ??? ?? ??? ???? ??? ???? ?? ?? ???? ???? ??? ????? ??? ??? ????? ??? ???? ????? ?? ??? ??? ?? ?????? ???? duplicated.When ???? ?? ??? ?? ??? ?? ????? ?? ?? ???? ????? "? ????? ????????? ???? ??????.
???: ?? ??? ?????? ????? ??????. ?? ????? ????? ??? ????? ??? ????; ?????. ?? ????? ??? ??? ????? ???????. ?? ???? ????, ??? ????? ?????? ???? ???? ??? ?? ??? ????? ?? ??? ????? ?????.

?????

??? ??? ???? ???? SQL ???? ???? ??? ?????? ????? ??? ? ????? ????? ?? ?????? ?? ???? ?? ????? ????? ??????. ?? ??? ??? ???? ?? ??? ???????? ??????? ??? ????? ?????? ???????. ????? ??? ?????? ????? Microsoft Access ??????? ????? ?????? SQL Server.

????

??? ??? ???????? ??? ?????? ??? ??? ????? ???? ???? Microsoft Jet 4.0. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
239114?????: ?????? ??? ???? ???? ???? ?? ???? ????? ?????? Microsoft Jet 4.0
?????? ??? ??? ???????? ?????? ???? ????? ??????? ???????.

???????? ????? Access

????? ??????? ????? Access ????? ?? ????? ?????? Access. ???????? ????? Access ?? ????? ??? ???? ??????? ??????? ?????? ?????? SQL Server.

?????? ??? ??????? ?????? ??? ????? ????? ?????? Access ??? ????? Access "? ???? ??? ???? ????????? ????????? ??????? ??" ????? ??????? ?? Microsoft:
241743ACC2000: "????? ????? ????? Access 2000" ??? ???? ???????? ?? ???? ???????
250616ACC2000: ????? ??????? DTS ??? ????? ???????? ?? ????? ?????? Microsoft Access ?????? ???? SQL

??????? ????? ?? ????? ?????? Access

??? ???? ??? ?????? ?? ????? ??????? Microsoft Visual Basic ????????? ???????? ????????? ?????? BeforeInsert ? ???_??????? ???????? ????? ????????? ?? ???????? ??????? ????????? ??? ????? ???? ??? ??????? ??????. ???????? ????? ???????? ???????? ????? ? ????? ????? ????? ???????? ????? ????? ?? ???????.

??????: ???????? ??? ??????? ?? ????? ???? ???? ???????? ???? ??? ???? ?????. ??? ??? ????? ??? ???? ?? ???? ??????? TAB ?? ??? ????? ?????? ??? ??????? ?????? ??? ???? ??? ?? ????? ??? ????? ?????? ? ????? ??? ????? ??? ?? ?????? ??? ??????? ??? ????? ?????? ??? ??? ???????. ?? ???? ??? ??? ????? ???????.
Option Compare Database
Option Explicit

Dim mfRequery As Boolean

Private Sub Form_AfterInsert()

    If mfRequery = True Then
        ' If the variable indicates a Requery
        ' is needed, Requery the form.
        Me.Requery
        ' Move back to the record that was just added
        DoCmd.GoToRecord acDataForm, Me.Name, acLast
        mfRequery = False
    End If

End Sub

Private Sub Form_BeforeInsert(Cancel As Integer)

    If Me.NewRecord = True Then
        ' If this is a new record, set a variable
        ' to indicate the need to Requery.
        mfRequery = True
    End If
    
End Sub
				

??????? ????? ?? MDB

??? ???? ??? ?????? ?? ???? ???? ???? ?????? resort ?????? ?? ????? ?????? ??? ??????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????.   ?? ????? ??? ??????? ?? ???? ???? ???? Microsoft Jet 4.0.

??????? ????

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

  1. ???? ????? ????? ???????? Northwind.mdb.
  2. ????? ?????? Orders (????????) ??? ????? ?????? ???? SQL ??????. ????? OrdersTest.
  3. ????? ????? ?????? Access ?????.
  4. ?? ????? ?????? ????? ????? ???? ????? ???? ??? ?????? OrdersTest ??????? ??? SQL Server.
  5. ??? ??? ????, ???? ??????.
  6. ?? ???????? ??? ??? ???.
  7. ?? ??? ??????? ??????? ???? ?? ??? ????.
  8. ??? ????? ?? ???? ???????? "? ???? ???????" ??? ????? "??? ?????? ???? ????? ??????.
  9. ???? ??? ???? ?? ??? ???? ??? ??? ???? ????? ?????? ?????.
  10. ?? ??????? ?????? ???? ??? Requery. ????? ?? ????? ???????.

???????

???? ???????: 251289 - ????? ??? ??????: 14/???? ??????/1435 - ??????: 2.1
????? ???
  • Microsoft Access 2000 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbpending kbprb KB251289 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????251289

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