B
bob
Hi we have now spent many hours trying different ideas but still have the
problem.
We have spent hours testing and have come down to the database runs fine
until someone adds a new record normally takes less that one second to do a
search then as soon as we click add a new record it takes 15 seconds to do a
search. if everyone closes the db and re opens it, it works fine again
until a new record is added. If everyone stays in the db it runs slow for
the rest of the day.
The code we use is:
DoCmd.GoToRecord , , A_NEWREC
Me.CustomerID2 = Me.Field143
Me.Registration_Number = "XXXXXXX"
Me.EmployeeID = [Forms]![SWITCHBOARD]![txtUserID]
Me.Salutation.SetFocus
Adding a new record seem to lock the system, any help or idea's would be
very much appreciated.
Bob
problem.
We have spent hours testing and have come down to the database runs fine
until someone adds a new record normally takes less that one second to do a
search then as soon as we click add a new record it takes 15 seconds to do a
search. if everyone closes the db and re opens it, it works fine again
until a new record is added. If everyone stays in the db it runs slow for
the rest of the day.
The code we use is:
DoCmd.GoToRecord , , A_NEWREC
Me.CustomerID2 = Me.Field143
Me.Registration_Number = "XXXXXXX"
Me.EmployeeID = [Forms]![SWITCHBOARD]![txtUserID]
Me.Salutation.SetFocus
Adding a new record seem to lock the system, any help or idea's would be
very much appreciated.
Bob