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?
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.