-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
There may be various reasons. One that is common is each user is
pulling a large recordset when they open a form. This will slow down
the processing. To correct this set up a search form, or routine on the
main form, that will allow the user to select one, or only a few,
records at a time.
An example: In the form's Header place a TextBox and a CommandButton.
Name the TextBox "txtSearch," label it "Search for Employee ID," and the
CommandButton "cmdSearch," label it "Find." Then create the following
routine:
Private Sub cmdSearch_Click()
' Set up the SQL to use whatever tables/columns you
' are using to fill your form.
Const SQL = "SELECT account_id, employee_id, sales " & _
"FROM AccountsReceivable " & _
"WHERE employee_id = "
If Not IsNull(Me!txtSearch) Then
' This will pull all the records for requested employee_id
Me.RecordSource = SQL & Me!txtSearch
End If
End Sub
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRAolpYechKqOuFEgEQJKJwCgw/7SLUozGjELnT7rfuaF9iMVbkIAnR4i
revW7eJyS0OTlhqgjO+c/KeE
=K/Sp
-----END PGP SIGNATURE-----
GGerard wrote:
I have just started using an application on a network(LAN) with multiple
users
I have the front end installed on different computers and the back end
(data) installed on the host computer of the network so that each computer
running the application links to the data located on the host.
When one user is logged on everything seems to work good ; access to the
data is normal.
When a second user logs on, the speed of access to the data, especially for
the second user, is greatly reduced.
It takes a long time to requery any forms for the second user.
For both the front end and the back end the following options are set:
Under Tools / Options /Advanced
DDE operations is Enabled ( check mark on "Enable DDE
refresh")
Default open mode is set to "Shared"
Default record locking is set to "No Locks"
Open databases using record-level locking is checked
I do not have the word "excl" written in the application's icon command line
The front ends are all MDE and are opened as Runtime
Any idea where I should look next?
I am using MSAccess 2000