odbc problems - currently locked records

  • Thread starter Thread starter phil
  • Start date Start date
P

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 ??
 
phil said:
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 ??
Click to expand...
 
Back
Top