Question,

I used lookup tables (using the lookup table wizard) when I designed my DB. Now that I've split the DB it's caused some serious slowness when forms are first open and all of the tables start looking elsewhere to pull data. Is it possible to break the relationships created by the wizard and then recreate the relationships and have the lookup be done by the form without having to completely rebuild the DB?

Thanks in advance...

Do you mean you used lookups in table FIELDS? Lookup tables in and of themselves are not a problem, but using them at table level is.

Yes, unfortunately that's exactly what I mean. :(

Yes, unfortunately that's exactly what I mean. :(
Just go into the backend and remove the lookups. You will find instructions here:
Remove Lookups (http://www.btabdevelopment.com/main/QuickTutorials/HowtoRemoveLookupsatTableLevel/tabid/141/Default.aspx)

Thanks much! I'll give it a shot and see what happens...after I back everything up, of course. :D

after I back everything up, of course.
GOOD - Yes - VERY GOOD! :)