Re: Cannot open Access table with ADO or BDE/ODBC

Vitali Kalinin wrote:
How many records in this table, are there any blobs, do you
experience same problem with server side cursor?

280,000 records No blobs. Not tried with server side cursor.
Not even really sure what that is:) But there is no "server" in this
scenario, unless you call JET a server.

.

Relevant Pages

  • Re: adResyncAllValues-Parameter funktioniert bei SQL Server nicht!?!
    ... wie Microsoft Access (Jet) unter der Voraussetzung die Entwicklungs- ... des SQL Überbaus) profitieren von einem serverseitigen Cursor, ... Wobei der SQL Server insofern schon die Ausnahme ... die Serverseitigen machen immer mal den einen oder anderen Ärger. ...
    (microsoft.public.de.vb.datenbank)
  • Re: VB connection to SQL server
    ... > the client machine begins to lose its relevance and accuracy as soon as it ... > aware that the data is probably out of date, a client sided cursor might ... > design minimises the possibility that records will have changed in the ... >> The Database server is in the office, and people use the Vb program from ...
    (microsoft.public.vb.database)
  • RE: Autonumber field alway set to 0 using OLEDB? Using ODBC work
    ... had the server side cursor, the KB article might not suitable for this ... you can install the latest service pack of Jet 4.0. ...
    (microsoft.public.data.oledb)
  • Re: Huge memory comsumption of ADODB Connection object
    ... unless the cursor is returning data to the client* I don't see ... I suppose this could cause some extra memory ... Is there a similar behavior in Sybase? ... Server was originally based on that rdbms, so there very well may be. ...
    (microsoft.public.data.ado)
  • Re: VB connection to SQL server
    ... "Chris Barber" wrote in message ... > recordsets (client side cursor) to allow you to persist the recordsets to ... aware that the data is probably out of date, a client sided cursor might fit ... That is because the SELECT statement is executed on the server and the data ...
    (microsoft.public.vb.database)