why did this happen?

[skate]

I split my database in 2 (one forms, one tables) and now it runs really slow. I noticed that all my relationships were deleted and had to add them back in in the tables db, but it still runs slow.

 

[pacsfo]

normal (kind of)

it's normal and it sucks!
It's all the traffic moving across the 2.
I ussually try optimizing the queries (bring only the needed fields and only the records that you need to display)
If you can, compile the front end and distribute it to the end users so that they can store it locally.

 

[pono1]

You can try this link if you're running Access 2000.

Too Slow

Regards,
Tim