Split database causing time delay

[cwbviper]

Our company has an Access 2000 database which is shared across the network and used by multiple users. The database is split into a front end for users and a back end for data storage. Recently we have been experiencing problems with the database having time delays loading and after a certain period of time the database hangs and creates a locked file on the desktop next to the database front end.

If anyone can suggest what the possible problem is and any solutions it would be appreciated.

Thanks

 

[Isadore]

cw: Is the front end an mde file? Pre-compiling the front end may help.

 

[cwbviper]

The front end is an MDB file, was experiencing other problems with MDE files. Problem is now remedied but thanks for the help.

 

[RemyS]

cwbviper,
I'd be interested in knowing what the actual problem was and how you remedied it?

I've been having the same problem with a split DB over a large network.

I believe, in my case, the delay and eventual hang is due to the traffic overload over the network,

but I'd be interested to know of other causes, and solutions.

Thanks,
Remy Hundreds of ways to do things with VB, and learning new ways every day.

 

[Isadore]

Rem: You may be right. I have a couple of databases on different networks and the network with the heaviest traffic also shows time delayed events while the same copy on a smaller network is very fast; so, first guest is that the network's functionality, and not the database, my be involved.