Slow since I Split DB

[DOA]

I have split my database.

I have the Backend on a share drive and I have the front on each persons machine.

Does anyone know the reason why it is slow, slower, quick and then slowest? and is there a any way I can speed it up?

Using Access 2000.

 

[lameid]

Network Traffic, File locks and perhaps record locking. Ultimately the best answer is to use a database server to house your data or live with the speed. The only thing you might clean up is record locking in your application. If Network traffic is a problem, then upgrading from say 10Mbs to 100Mbs would help. And of course switches instead of hubs may help. Also dedicating a machine to the database on a network with a switch would also help if the machine hosting is hit with a lot of traffic. Keep in mind all these solutions other than the database server will help but you might not see a decent ROI.

 

[AvoTohver]

If Your network speed is ok then there is other possible cause. For example if You are keeping only one form open at the time it might be the connection problem. Each time opening the form also the connection to database must be created because You have no other tables opened before.
Workaround:
On the startup open just small recordset from backend database using Visual Basic code and do not close it. NB! recordset variable must be static or global. This keeps connection open during session and other recordsets open much faster.

 

[DOA]

Thanks- I have it on a pretty fast server with scci hard drives.
The network is not that bad as it is all 100mb. All forms are uncontrolled and I have the code open and close (set =Nothing) the DB's. I don't use variable as constants.

I will try the dummy DB and open it. I have the close on the exit button.
I’ll get back to you latter this week with the results
Thanks again for everyone’s help.