Svgmassive
asked on
Best Approach MS Access 2013
We have just import old files into a new system,I am looking for the most efficient way to search the table of over 100000 records from a
dynamic query (user input),modify an existing query and display the results.I have read that DAO is the preferred method.It's takes about 0.078 seconds to filter out 8779 records.I have done the indexing on the table,remove the sorting.There are list boxes on a form that the user determine's the criteria.
Any ideas?
dynamic query (user input),modify an existing query and display the results.I have read that DAO is the preferred method.It's takes about 0.078 seconds to filter out 8779 records.I have done the indexing on the table,remove the sorting.There are list boxes on a form that the user determine's the criteria.
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.