Updating latge recordsets takes long time in ms access database
As an Access developer — or even as a power user — you won't get far if you can't work with the Recordset object.
One of those happens to be grabbing every Crystal Report file in a directory that at last count had My client updates this particular project every year since I first created it back in 2005.
You don't build these slow databases, users do — but you might need to support them.
Users build them and then they call you: There are things you could do to help, but the good news is that you can offer a few tips that might help them improve performance on their own.
For more information, see the article Create and use an index to improve performance and the links in the See Also section.
The Name Auto Correct feature helps ensure that the functionality of database objects remains intact when other database objects that they depend upon are renamed.