my Access app has many recordsets open (over internet). the connection
fails from time to time. all recordsets use adUseClient,
adLockOptimistic
having read some posts i understand that the _recommended_ method is to
disconnect the recordset after creation and connect it on the fly and
disconnect it after use. is this correct?
how could this be implemented on a access form? ie; delete, insert,
update operations
(i'm guessing there are Access users here)
Error updating records in ADO disconnected recordset ... The database resides in SQL 2000, ... The application uses grids extensively to display the contents of recordsets.... The application works without error if connected to a jet database.... 'POPULATE RECORDSET AND DISCONNECT... (microsoft.public.sqlserver.odbc)
Help updating disconnected recordsets in ADO VB 6.0 app ... The database resides in SQL 2000, ... The application uses grids extensively to display the contents of recordsets.... The application works without error if connected to a jet database.... 'POPULATE RECORDSET AND DISCONNECT... (microsoft.public.vb.database.ado)
disconnected recordset form ... my Access app has many forms backed by recordsets open. ... all recordsets use adUseClient,...disconnect it after use. ... (microsoft.public.access.forms)
Re: Stand Alone Recordsets ... rst.CursorLocation = 3 ' adUseClient... rst.CursorType = 1 ' adOpenKeyset... I believe these settings are ignored for ad hoc recordsets....Dim sName... (microsoft.public.data.ado)
Re: RS.open ist schnell, folgendes RS.? lahm ... >> Dann solltest du es lieber mit adUseClient versuchen, ... Eigenschaften dieses Recordsets geprüft?... Öffnen der Connection und zum Öffnen des Recordsets sieht. ...Code "auf der Arbeit" verwende. ... (microsoft.public.de.vb.datenbank)
