Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167

    Unanswered: Slow querying of .dbf datasheets

    I'm having some trouble querying local linked .dbf tables in Microsoft Access. They run correctly but they are taking forever to run. Has anyone encountered this and if so, how did you remedy the problem?

    Thanks,

    Joshua

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Personally, I would import the dbf files into corresponding Access tables and run the queries from them. Ideally, I would stop using dbf files entirely, but that's not always possible.
    Have a nice day!

  3. #3
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    Sinndho,

    That would be my preferred method too, taking a snapshot. Unfortunately, the tables are too big and I'd have to import them in at least once a month which takes a very long time.

    Joshua

  4. #4
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    I am encountering an error when I try to link to the Dbase files where it requests the index file (.ndx or .mdx). I don't have this so I hit cancel and it creates the linked table in Access anyways. When I try to go in to manually change the index it does not let me because it is read only.

    Joshua

Posting Permissions

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