could not update,currently locked

[Guest]

I have a splited database,database part stays on server(win2000),microsoft
network..etc
Aplication is running on 15-20 workstation(frontend)
database part is opened shared-no locks,check box is marked/use record level
locking
aplication on front end is also shared-no locks-record level locking
I have one table opened continuosly by this app. 15 users ,other parts of
aplication are working ok but working in this table at the same time but not
in the same record causes - messages could not update, I'm sure that no one
is particulary in that record but the messages is display. also after that
whole system is blocking for several minute in this workstation
This particulary table is constantly open by two different forms (open by
querry) on each workstation but users try to stay not in record ,better not
in writing the data
I'must say that the network is in the bad shape and the server is loaded
with other transaction beside my aplication
there are to many forums about this particulary problem and most of them
are not offering the solutions ,only comments, so if someone have the
possible solution please answer ,
greetings from croatia
dee

 

[Joseph Meehan]

I have a splited database,database part stays on
server(win2000),microsoft network..etc
Aplication is running on 15-20 workstation(frontend)
database part is opened shared-no locks,check box is marked/use
record level locking
aplication on front end is also shared-no locks-record level locking
I have one table opened continuosly by this app. 15 users ,other
parts of aplication are working ok but working in this table at the
same time but not in the same record causes - messages could not
update, I'm sure that no one is particulary in that record but the
messages is display. also after that whole system is blocking for
several minute in this workstation
This particulary table is constantly open by two different forms
(open by querry) on each workstation but users try to stay not in
record ,better not in writing the data
I'must say that the network is in the bad shape and the server is
loaded with other transaction beside my aplication
there are to many forums about this particulary problem and most of
them are not offering the solutions ,only comments, so if someone
have the possible solution please answer ,
greetings from croatia
dee

As I recall, that application should be locking a "page" not a record.
That Page may involve one or more records.