i have shared a DB in 2010 through LAN but still at the second pc where it is working as shared opening slow and working slow... rest it is working fine at main pc where it is present.
Both PC having Win 7 64 Bit with Office 2010 Suit 32 bit
this may somewhat make it faster.
always maintain an open Linked table when you start the db.
this can be done by creating a dummy bound hidden form that can be open through autoexec macro. the rowsource of the hidden form is a Linked table (either a dummy one too).
this may somewhat make it faster.
always maintain an open Linked table when you start the db.
this can be done by creating a dummy bound hidden form that can be open through autoexec macro. the rowsource of the hidden form is a Linked table (either a dummy one too).
no the DB is not splitted i am trying to split it and it was splited at time but after few entries or in idle mode it stop working and showing error like ... reference not....... i think is LAN issue ? because if we work continously on shared db then it works fine but when we stops or idle.. it for 10 to 15 minutes then it takes time to open forms etc...i checked the LAN cable it is fine.. what to do
But suppose if FE is Idle for 10-15 minutes then will it continue to start or again that error which i am facing.. please tell me is it not a laptop sleep issue as the said laptop sleeps after 5 minutes and we face this ??
Means is it possible that if laptop is in sleep mood then it may hang or drop LAN connection for a while till any application re-activate it ? is it possible?
Yes afraid so - if your laptop goes to sleep, than it normally shuts down your network connection to preserve power. So even a access "forced" background connection doesn't persist. Which will cause an access error.
Only thing you can do is prevent the sleep mode if the laptop is plugged into the mains connection, if it's plugged in you don't need it to sleep. Just turn the monitor off to prevent screen burn.
