Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Indexing

Discussion in 'Information Technology' started by Hugh Welford, Jul 28, 2006.

Tags:
  1. Hugh Welford

    Hugh Welford
    Expand Collapse
    Guest

    Hi - trying to optimise ACCESS 200 db for use on the web, and have received
    the following advice from the .asp newsgroup

    "Proper indexing. use the database utilities included with Access to
    optimize your database. See an Access newsgroup for help."

    Can any one help, or recommend an article on this.

    Thanks

    Hugh
     
  2. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Hugh,

    Here are a couple of KB articles that you may find helpful on this subject:

    How to add an index to an Access database (in Access 2002)
    http://support.microsoft.com/?id=304266

    (ACC2000:) Compound Indexes Must Restrict First Indexed Field
    http://support.microsoft.com/?id=209564

    I added the parenthesis around the indicated versions of Access, because the
    information should apply equally well to other versions of Access. I
    recommend experimenting with the JETShowPlan registry change. For more
    details, see this article:

    Implementing a Successful Multiuser Access/JET Application
    http://www.access.qbuilt.com/html/multiuser_applications.html

    See the sections titled "Use indexes" and "Use JETSHOWPLAN".


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Hugh Welford" wrote:

    > Hi - trying to optimise ACCESS 200 db for use on the web, and have received
    > the following advice from the .asp newsgroup
    >
    > "Proper indexing. use the database utilities included with Access to
    > optimize your database. See an Access newsgroup for help."
    >
    > Can any one help, or recommend an article on this.
    >
    > Thanks
    >
    > Hugh
    >
    >
    >
     
  3. Hugh Welford

    Hugh Welford
    Expand Collapse
    Guest

    Thanks Tom


    "Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
    news:58F5791F-F26A-4A31-9F77-448593B8BE04@microsoft.com...
    > Hi Hugh,
    >
    > Here are a couple of KB articles that you may find helpful on this
    > subject:
    >
    > How to add an index to an Access database (in Access 2002)
    > http://support.microsoft.com/?id=304266
    >
    > (ACC2000:) Compound Indexes Must Restrict First Indexed Field
    > http://support.microsoft.com/?id=209564
    >
    > I added the parenthesis around the indicated versions of Access, because
    > the
    > information should apply equally well to other versions of Access. I
    > recommend experimenting with the JETShowPlan registry change. For more
    > details, see this article:
    >
    > Implementing a Successful Multiuser Access/JET Application
    > http://www.access.qbuilt.com/html/multiuser_applications.html
    >
    > See the sections titled "Use indexes" and "Use JETSHOWPLAN".
    >
    >
    > Tom Wickerath
    > Microsoft Access MVP
    >
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > http://www.access.qbuilt.com/html/search.html
    > __________________________________________
    >
    > "Hugh Welford" wrote:
    >
    >> Hi - trying to optimise ACCESS 200 db for use on the web, and have
    >> received
    >> the following advice from the .asp newsgroup
    >>
    >> "Proper indexing. use the database utilities included with Access to
    >> optimize your database. See an Access newsgroup for help."
    >>
    >> Can any one help, or recommend an article on this.
    >>
    >> Thanks
    >>
    >> Hugh
    >>
    >>
    >>
     

Share This Page