Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Earth | North America | United States | California | Long Beach
    Posts
    62

    Unanswered: Tables in Access 2000 After Conversion

    I have converted several databases from Access 97 to Access 2000. With each database I have to wait about 25 to 30 seconds to open the tables (non linked). I have also converted the tables individually from 97 to 2000 with the same slow response.
    Within 97 these tables open upon my double click.

    Does anyone know why this occurs and what the solution is for this problem?

    Thanks,
    Jack

  2. #2
    Join Date
    Jul 2003
    Location
    Earth | North America | United States | California | Long Beach
    Posts
    62

    Re: Tables in Access 2000 After Conversion

    I also tried a db split. When I do this the linked table (within 2000) opens a little faster. But, when I go to the database that has the tables (the BE database) it is lightning fast (just as with 97).

    Any thoughts or remedies are greatly appreciated.
    Jack


    Originally posted by Jaash
    I have converted several databases from Access 97 to Access 2000. With each database I have to wait about 25 to 30 seconds to open the tables (non linked). I have also converted the tables individually from 97 to 2000 with the same slow response.
    Within 97 these tables open upon my double click.

    Does anyone know why this occurs and what the solution is for this problem?

    Thanks,
    Jack

  3. #3
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    I have seen this behavior with converting db to 2000 and to xp for that matter

    if you run a select query against the table how is your response time?

  4. #4
    Join Date
    Jul 2003
    Location
    Earth | North America | United States | California | Long Beach
    Posts
    62
    That is a great question. That is what puzzles me the most. The queries run much faster in 2K than they did in 97. So that is encouraging.

    Jack

    Originally posted by axsprog
    I have seen this behavior with converting db to 2000 and to xp for that matter

    if you run a select query against the table how is your response time?

  5. #5
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    exactly
    any report or form that is using the table as the recordsource should be using a query or sql statement instead

    try that - it is not really an explanation of the behavior, but it is a work around

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •