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?

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
-AJ

Thanks for the heads up I will give it a try and if I can speed things up a bit.

Other info on performance => Microsoft Access Performance FAQ

HTH

Greetz from Belgium

Luc aka Kuifjexx