i just split my database and put the BE on the network.
when i open up my FE and just open the design view of a query (no records loaded only just design view), it takes a long time to open up. however in my non-split database the query design view opens up instantaneously.
1) why does my split database open the query design view
(the query name i'm opening is opxTopContainer_Sorted)
2) do yall usually develop your entire application then load it on the network or develop it half way and then load it on the network to test and continue development or just develop from the network all the way?
i think for me i should develop on the network all the way cause there are many things i can't predict (due to lack of experience) as to how slow it would be on the network. so if i develop on the network all the way i will have instant feedback and change things along the way instead of almost completing the whole project then realising that i have some major problems in it as i've not factored the network speed.