ACC: ????? ????? ???? QueryTimeout ???????? ODBC

?????? ????????? ?????? ?????????
???? ???????: 153756 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???: ????? ??? ??????? ??? ??????? ??? ????? ????? ?????. ??? ????? ?????? ??? ????? ????? ???? ???????? ?? ????? ??????? (System.dat ? User.dat). ?? ?? ??????? ??????? ?? ???? Windows.

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

???? ??? ??????? ????? ????? ??????? QueryTimeout ??????????? ???? ??? ??????? ????????? ?? ????? ?????? ODBC.

??????? ????

??? ??????? ????? ?????? ODBC "? ??? Microsoft SQL Server? ?? ???? ???? ????? ????? ?????? ???? ?????? ?? ????? ???? ??????? ???? ODBC. ????? ?? ?????? ???? ??? ?????, ????? ????? ??? ???????? ??? ???? ????? ?????? Microsoft Jet ???? ???. ????????? ????? ??????? QueryTimeout 60 ?????. ??? ??????? ?? ?? ???? ?????? ?????? ??? ??????????? ????? ????? ?????? ODBC. ??? ??????? ??????? ????? ????? ??????? QueryTimeout.

??????: ??? ??????? "??????? ??????" ?????? ??????? QueryTimeout ? ?????? ???? ????? ????? QueryDef ?????. ??? ????? ??????? ???? ???? ????? ?????? ??? Microsoft Access 97 ???????? ??????? QueryTimeout 60.

??????: ??? ??????? ??????? ???????? ?? "??????? ???????" ?????? ?????? QueryTimeout ???? ??????? "? ???? ?????? ?? ??????? ??????? ????????? ?? Microsoft Access ???? ???? 60 ??????? QueryTimeout. ??? ???? ?????? ??? ??????? ???? ?? ???? ????? ??? ??????? ???????, ????? Microsoft Access ??????? ?????? ???? ??????? ?????? ??? ???????? ??? ???? QueryTimeout.

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

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

????? ?????? ????? ???? ??????? ??? ??? ????? ????????:
   Sub SetTimeout()
      Dim Mydb as Database
      Set Mydb=CurrentDB
      MYdb.QueryTimeout=120
  End Sub
				

????? ????? ??? ??????? ?????? ?? ????? Windows ????? ?? ?????? ??????????.

??????: ??? ???? ???? ??? ????? ?? ??????? QueryTimeout ??? ????? ??? ??????? ??? ????? ???? ?? ???? ????? ?????? Microsoft Jet ?????? ??? ??????? ?? Microsoft Access. ??? ??? ?????? ??? ??? ????? ????? ?? CurrentDB.QueryTimeout ? ?? ????? ?????? ??????? DBEngine (0)(0). ??? ???? ??? ???????? ?? ???? ???? ??????? ?????? ?? ???? ????? ?????? Microsoft Jet.

?????? ??? ??????? ??? ????? ?????? ??? Microsoft Jet 3.51 ?????? ?????? ??????? ??????? ?? "????? ??????? ?? Microsoft:

172733ACC97: ????? ??????? ?? Microsoft Jet 3.5 ???????? ???????

?????? ??????? DBEngine


  Sub mytest()
     Dim mydb As Database
     Set mydb = DBEngine(0)(0)
     mydb.QueryTimeout = 120
     MsgBox mydb.QueryTimeout
  End Sub
				

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

????? ??????? ?? "???????".

?????: ???? ????? ??????? ???? ??????? ???? ??? ???? ?? ???? ?????? ????? ???? ????? ????? Windows. ??? ???? Microsoft ?? ????? ?? ?? ??????? ??????? ?? ????????? ??? ?????? ????? ???????. ?????? "???? ???????" ??? ???????? ??????.

?????? ??? ??????? ??? ????? ????? ??????? ??? ????? ????????? ??? ???????? ??? ????? ???????? And ?? "???? ???????" (Regedit.exe). ?????? ??? ??? ???? ???????? ?? ????? ??????? (System.dat ? User.dat) ??? ????? ???????.

???????? Microsoft Access 97


  1. ????? ??? ????? ??????? ??????:
         HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.5\Engines\ODBC
    						
  2. ??? QueryTimeout ???? ??? "?????" ? ?? ?? ??????. ????? ???? DWORD ??? ??????? ???????. ???? ?????? ??? ??????? ?????? ????.

???????? Microsoft Access ??????? 7.0


  1. ????? ????? ??????? ??????:
        HKEY_LOCAL_MACHINE\Software\Microsoft\Access\7.0\Jet\3.0\Engines\ODBC
    						
  2. ???? ??? ????? ? ???? ?? ?? ???? DWORD. ?? ?????? QueryTimeout ?? ????? ?????? ??? ???? ??? ????. ??? ???? ??? ?????? ??? ??????? ?????? ????.
??????: ??? ?? ????? ??? ??????? ??? ??????? ????? ????? Microsoft Access, ????? ??? ????? ????? ?? ????? ??? Microsoft Access ??? ?? ??? ?????? ??? ???????.

?????

?????? ??? ???? ?? ????????? ??? ????? ????? ????????? ????? ?????? ?????? ?????? ??????? ??????? ?? "????? ??????? ?? Microsoft:

135120????? ???? ????? ????????? ?? ????? ????????? "???????"

???????

???? ???????: 153756 - ????? ??? ??????: 29/?? ?????/1427 - ??????: 3.1
????? ???
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
????? ??????: 
kbmt kbhowto kbusage KB153756 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????153756
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

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