I work at a place with a couple dozen MS-Access DBs. Many are Very Slow to work with. And a some have "extra" tables when I view the table relationships. What are those all about?

Here is a snapshot of the relationships.

http://www.box.net/shared/szmsd18omu

These "extra" tables I guess are created by all those relationships people have created for "drop down" lists etc.

I need better system performance, it is sooo bad now a query to pull 1700 records from a table of 16000 records takes 5 minutes then to jump to the bottom of the output of the query another 10 minutes, just to see i did not get what I need. This is effecting everyone's productivity that works with the DB.



To get better performance to get results would a good idea be to copy the DB and break as many of the relationships as I can. Then do my queries??

Thanks for help Russ rneuman @ scaninc.org