Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FE / BE performance on network

Status
Not open for further replies.

MajP

Technical User
Aug 27, 2005
9,382
US
I am not sure if this is an Access questions or a network question. I know a little about Access and nothing about networks. I have a split database with all users running the front end off their local machines with their own copy of Access.
For testing purposes I ran the front end and back end on my computer. I tested it with multiple instances of Access running and it worked fine. Once I put the back end on the network, the application became unusable once more than one user was running the front end. Forms that took 2 seconds to load, took about a minute to load. Any larger forms just locked up the application. The front end is compiled, compacted, and is tested as both an mde and a mdb.
Anyone have suggestions on strategies or things that I should explore.
Thanks
 
evalesthy,
Thanks for the FAQ. There is some good stuff in there.
 
Unbelievable. In the FAQ it talks about turning the AutoCorrect Track Name feature off. I knew nothing about this. Once I did this everything went about 100 times faster. Go figure. This is an important piece of information. I also created a dummy hidden form to lock the .ldb file and this seemed to solve all my problems. Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top