network performance

[puthenveetil]

Hi all,

I had a database which is splitted to BE and FE. I had copied FE to all the user computers and it is working fine. My issue is that when two or more users access the DB same time, it is taking around a minute to load the forms..If only one user, then it flies...Anyone had any idea to solve this issue or somebody facing same issue????

thanks in advance


Thanks

 

[The_Doc_Man]

Check the locking options on the forms and on any tables. You might have them set a bit too restricted. Like, maybe, set to TABLE locking when you really wanted RECORD locking... or rarely NO locking.

That applies to ANY table or query or recordset underneath the form, too, not just one that is bound to the form.

 

[John.Woody]

I'm facing the same issue, but only when Windows 2k with all the service packs, or Windows XP is the server PC. If I put the data files on a Win 98 pc I get all of my speed back. Will check my record locking but am pretty sure record locks are set to no locks.

 

[The_Doc_Man]

Just as a wild-eyed guess, check the permissions on the folder holding the DB to be sure that all users have the ability to create and delete files in that folder as well as to modify existing files. You might be running into an issue with the .ldb file rather than the .mdb file.

 

[Meltdown]

Make sure the Name AutoCorrect feature is turned off under Tools > Option > General, I've noticed a big increase in performance.

No harm to read through FMS's 168 Ways to speed up Apps:
http://www.fmsinc.com/tpapers/faster/index.html

 

[John.Woody]

Folder permissions are correct. I've tried taking out all of the code on my main menu and then it loads quickly. Then I tried removing bits of code at a time but no matter what the performance goes dowm hill. On loading the form I'm running some screen stretching code, making sure the form is maximized and doing a lookup. Other than that there are buttons with code to open other forms.