We have an application developed using ADO with Access as the database. We're trying to tune the application to improve it's performance..Can u please give us some information regarding.
1. IMproving the speed of the application?
2. Inherent disadvantages that Access has within it self?
3. The maximum performance that we can get, if we consider
say for e.g 32,000 records, in 10 tables, with say an
approximate overhead per record of 10 SQLs of varying
complexity..
4. Any tips on ADO to improve the performance..
