Jul 27 2004, 02:26 PM
As more and more linked table have been added to my DB I have been experiencing a bigger and bigger slow down. I went to http://support.microsoft.com/?kbid=261000
and read that performance could be improved by setting my linked table Subdatasheet Name from Auto to None. They provide code to do this all at once or it can be done manually. I was wondering if anyone has tried this and did it help? Are there any hazzard in doing this?
Jul 27 2004, 02:31 PM
It helps IMMENSELY.
There is no hazard in doing this, as long as you are not permitting your users to view the tables directly, and do not allow your forms to go to datasheet view.
Doing this disables the drop-down that shows the related records from another table. Normally, these are available when the table is open directly or a form goes to datasheet view. If your users need these, leave Subdatasheet at Auto for the appropriate tables.
hope this helps
Jul 27 2004, 02:51 PM
Thanks for the heads up I will give it a try and if I can speed things up a bit.
Jul 27 2004, 03:54 PM
Other info on performance => Microsoft Access Performance FAQ
Greetz from Belgium
Luc aka Kuifjexx