odbc problems - currently locked records

[phil]

we have an app that ran fine until we upgraded
to windows 2000 server and xp workstations.

We have sp2 on the workstation and sp1 on the
xp machines.

now when as little a 3 persons are in the application
it locks the table when adding a new control number in the
table
the other machines can't access the table.

we have disabled opportunitic locking on the server.

we have tired to change the way we open the table
to get the next control number

any ideas ??

 

[souk kimlong]

we have an app that ran fine until we upgraded
to windows 2000 server and xp workstations.

We have sp2 on the workstation and sp1 on the
xp machines.

now when as little a 3 persons are in the application
it locks the table when adding a new control number in the
table
the other machines can't access the table.

we have disabled opportunitic locking on the server.

we have tired to change the way we open the table
to get the next control number

any ideas ??