Slow network database

[tinwolf]

This problem is driving me nuts!!
I`ve just spent a fair few months creating a database to be used by our sales team, I`ve about finished it and came to trial it with the sales manager. When he is using the database at the same time as me it becomes slow.
The design has a front end with all the queries, forms etc and a back end on a server containing the tables.
The database was created using Access 2000 and was designed to replace a similair db created on 97 which has a decent speed on the network.
The other strange thing is that one particular macro that I`ve been using for the speed tests runs quite slow (about 3 secs) when 2 pcs have the db open but once the macro has run if it is run again it takes typically less than a second to run.
What would cause a db to run a macro at different speeds after they`ve been run once? I`ve tried everything I can find on the net to try and improve the speed to no avail.
Help please!!

 

[RuralGuy]

Have you reviewed the elements of this link, especially the persistant connection? Microsoft Access Performance FAQ

 

[John.Woody]

If your data file is on Windows XP or a dedicated server the following may apply:

Turn off the sharing violation notification delay
You can turn off the sharing violation notification delay to improve file server performance. To do this, follow these steps on the file server that stores the Access or Jet database engine-based program database.

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.1. Click Start, click Run, type regedit, and then click OK.
2. Locate the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
3. Right-click Parameters, point to New, click DWORD Value, type SharingViolationDelay, and then press ENTER.

Note When you create the SharingViolationDelay subkey entry, the default value that is assigned is 0x0. This is what we want.

If the SharingViolationDelay subkey entry already exists, right-click the SharingViolationDelay entry, click Modify, type 0, and then click OK.
4. Right-click Parameters, point to New, click DWORD Value, type SharingViolationRetries, and the press ENTER.

Note When you create the SharingViolationRetries subkey entry, the default value that is assigned is 0x0. This is what we want.

If the SharingViolationRetries subkey entry already exists, right-click the SharingViolationRetries entry, click Modify, type 0, and then click OK.
5. Quit Registry Editor.
For more information about the sharing violation notification delay, click the following article number to view the article in the Microsoft Knowledge Base:
150384 (http://support.microsoft.com/kb/150384/) Shared file access is delayed if the file is open on another computer

This is documented by Microsoft
http://support.microsoft.com/default.aspx?scid=kb;en-us;889588

Note: It doesn't work with XP Home. I have found that it really works for a good number of my customers.