Performance decreased a lot after adding a single field
Posted on 2003-03-14
Given a database Access 2000 front end (MDE type) connected using ODBC to tables on a MS SQL server 2000.
Performance has been very fine until today, where I added a single field (type real) to one table.
I have an older version of the front end (MDE type) connected to the same tables in the same SQL back-end database. This version has'nt had any decrease in performane.
In the MDB file I reconnected the tables to get the new field available.
After that operation, the performance of the MDB file (and the new compiled MDE) file has decreased a lot. In fact it is totally useless.
The old MDE file (which has'nt the new extra field) still works fine and fast.
I have tried to add an extra index with the new field, but that has not changed the performance.
Please: Can anyone explain why does the performance suddenly decrease so much and what should I do?