Re: Any reason why accessing Access should slowdown?

On Sun, 1 Oct 2006 02:21:02 -0700, JohnBury <JohnBury@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

¤ I am writing a VB6 App using an Access database backend (not clever but cheap!)
¤
¤ Yesterday the performance of data access became unacceptably slow, from near
¤ instantaneous to 10 seconds to retrieve 4 records to fill a datagrid.
¤
¤ It happened after I had added a new table to fill a combo box with default
¤ values. I 'regressed (removing new code and references to the new table, but
¤ performance as still poor. Something like this has happened before and was
¤ fixed by a database repair, but not this time!
¤
¤ Any ideas where I should look for my problem?
¤

This database isn't located on a network resource is it?

I typically don't recommend using the Microsoft Access ODBC driver since it isn't as stable as the
Jet OLEDB Provider.


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

Relevant Pages

  • Re: Load Picture from MS Access to VB6
    ... in code to compact the database via a menu option. ... there is a chance the filename of the photo itself can ... > ¤ Well, I figured it out I think. ... loaded images into the database directly through Access (so that I could ...
    (microsoft.public.vb.general.discussion)
  • Re: Please Help Me in Visual Basic 6.0 SP6
    ... Dim dbPath As String ... Above is my programming where in this programming, ... how can i indicate myself which one i'm gonna insert to the database. ... > ¤ solution where as somebody can help me where to start. ...
    (microsoft.public.vb.database)
  • 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: Copy database schema from Access to SQL Server
    ... It can import a JET database in a single stroke. ... Hitchhiker's Guide to Visual Studio and SQL Server ... ¤ projects to SQL Server, ... schema and then use DDL code to create the corresponding objects in SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Dynamic MDB creation for specific formats 2000-2007
    ... If the specific format could be created from the outset - ... the resulting database - if they were - wouldn't care about any of this. ... ¤ If the database is being created on one system which by default creates ... It doesn't matter when accessing the database through Jet ADO or DAO. ...
    (microsoft.public.vb.database.ado)
Loading