So it looks like I am back to this issue. Heres whats going on.
When a report is opened, it takes about 10-30 seconds to open. The first attempt takes the longest, and it opens faster and faster at every attempt to open it, unless the data or parameters change, then your back to waiting for it to open.
This happens with a split version and a version that is not split. Don't know whats going on, but this sucks because I am done development. Please help!
edit: I just found out that on the fifth try to open, it is back to square one, it takes forever again. Does access start clearing its memory after 5 new windows are opened? This also seems to happen if the focus leaves access. If you are on the second try to open, it should open fairly quick, unless you loose focus of access. When you try to open it, it takes a while. I don't get this!