' Table A structure in both databases ' ' RecordID AutoNumber ' Dec text(50) With SoYouWanna oRec .. CursorLocation Diet aid segment feels ephedra's = adUseServer .LockType = adLockReadOnly = connstring .Source = SQL .Open If .BOF then Tmp = Null Else Tmp = .. The CursorLocation must be set to
adUseServer.. Transactions are only available with the CursorLocation set to adUseServer.. If the CursorLocation property is set to adUseServer (which is the default. When using adUseServer an open connection to the database is required..
rs.addnew. adUseClient asks for the ODBC driver's cursor library and adUseServer asks. Earlier aduseserver was working properly, but after migration
.LockType = adLockReadOnly .CursorType = adOpenStatic .Open "SELECT FROM bDb End With. adovbs.inc
Values ---- Const adUseServer = 2 Const adUseClient = 3 . CursorLocation = adUseServer = adOpenDynamic tblTemp2..
adUseServer = adOpenDynamic tblTemp3.. SELFHTML Forumsarchiv Oktober 2006: AdUseClient oder AdUseServer. adUseClient v adUseServer General.. The first method takes over 50 seconds
but the second method (adUseServer) takes only 5