Re: Any reason why accessing Access should slowdown?

On Mon, 2 Oct 2006 08:20:02 -0700, JohnBury <JohnBury@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

¤ Paul
¤
¤ The database is on the same machine as the VB application.
¤
¤ On the MSACCESS / JET OLEDB front, you responded to a query I had about the
¤ problems I was having with JET, but I never really resolved the issue.
¤
¤ To remind you, when I repolaced my connection string so that it used JET, my
¤ application stopped being able to display filtered data in datagrids.
¤
¤ If you wish to continue thie dialogue on this issue then...
¤
¤ This is what I did
¤
¤ At design time...
¤ Declared connection to Access database using string based on Jet OLDB
¤ provider.
¤ Created an ADODC on my form with datagrid.
¤ Used ADODC to initially load columns to allow me to format grid
¤ removed reference to ADODC from grid's datasource property
¤
¤ At runtime
¤ during Form Load
¤ Set up recordset filter in response to earlier input / selection
¤ Set datagrid datasource property to recordset
¤
¤ What happens? Nothing! I can display recordcount of filtered recordset in
¤ the immediate window, but datgrid refuses to display records.
¤
¤ Swap connection back to use MSACCESS provider and it works fine!
¤
¤ My recordsets are opened as 'adKeySet'
¤
¤ Cursors are all client side
¤
¤ If you have any ideas I would welcome them!

So if I understand the problem correctly, the Recordset Filter works properly but the data binding
to the DataGrid fails?


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: Any reason why accessing Access should slowdown?
    ... On the MSACCESS / JET OLEDB front, you responded to a query I had about the ... Declared connection to Access database using string based on Jet OLDB ... Set up recordset filter in response to earlier input / selection ... ¤ I am writing a VB6 App using an Access database backend ...
    (microsoft.public.vb.database)
  • Re: Requery Method Does not Work
    ... Dim rsCCIDistinctDias As New ADODB.Recordset, rsCCIPinCheck As New ... rsCCIDistinctDias Recordset ... ¤ It does not refresh the data in the rsCCIPinCheck recordset. ...
    (microsoft.public.vb.database)
  • Re: Add new record in DAO recordset locks entire table (using transaction on linked tables)
    ... Is opening the recordset before the starting the transaction means ... ¤ I'm having problem with using DAO recordset in MS Access 2000 to append ... So it only lock the entire table when using transactions on ...
    (microsoft.public.vb.database.dao)
  • Re: VB6 ADO and Access 2000 #Error in field
    ... The Jet driver loads Empty where #Errors occur. ... > ¤ Where strcurrentpath and strcurrentdb are pretty obvious variables. ... the recordset that was returned was messed up. ...
    (microsoft.public.vb.database)
  • Re: Oracle 9 and 10g and VB6 ADO virtual memory issue
    ... ¤ Hi, ... database which download records to a local database with no issues. ... We are also in the process of upgrading to Oracle 10g. ... still works but for some reason when reading a recordset it seems to ...
    (microsoft.public.vb.database.ado)
Loading