Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Question Unanswered: Split table, now slow?

    Hi all

    I was hoping to get a little advice as to my problem. I have a database with many, many reports, forms and queries. I wanted to split the database to secure the tables and important data. So I use the database splitter wizard and ever thing went just fine. So now my database1 looks into database1_be for all tables.

    My problem is: my program now runs very slow. The slowest seems to be when I am adding a new record. I can live with the slowness of retrieving an existing record. I do not have a server nor can I afford one at this time, so currently I am running a peer-to-peer network with the database1_be located on one of my computers second hard drive.

    Is there something I can do to help speed things up?
    Thanks Enviva

  2. #2
    Join Date
    Jun 2002
    Mpls/St.Paul area
    A slower reponse is one of the realities of looking over a network for data.

    One suggestion to ameliorate (nice word huh?) the situation is to look at each table in design mode. Change the subdatasheet Name property of each table from the default [auto] to [none]. Do this to the real tables in the back end of course.

    Additionally, do a search for performance in Microsoft's knowledge base for MS Access.
    This is the day the Lord has made, I will rejoice and be glad in it.

  3. #3
    Join Date
    Feb 2004
    Chicago, IL
    If adding records is slow, you will want to look at how many fields and indexes you have on the table. The more you have of each the slower it will be to add records.

    I would look primarily at the indexes and see if any of them can be removed. Any indexes on a boolean field can be removed. Any on fields you don't really search on can be removed.

    You also might try Compacting and Repairing both databases.

    If you look in Tools, Options, Advanced Tab, what is your default Record Locking set to?

Posting Permissions

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