Ok,
well the patch did not actually "fix" the issue. It did make the switch between the two faster.
Procedure we use to run both. Install tracking software 1st with no version of access at all. It will install 2002 runtime, install access 03 and then install access 07. Without access 03 it just will not run. it will run with access 03 installed. It doesn't matter which you install 1st really, thats just the order I did it this last time. Although, when I use access 07 and then close the application. Then start the other application (check in/out) 2002 runtime will configure and run the app. Not access 03. The switch is much faster with the sp1 patch than without it, so thats a plus. I think its more complicated then just access 02, 03 and 07 I think there is also issues with the .net and iis versions. //sigh
the errors that are popping up appear to be VBA refs on macros just fyi.