I'm administering a small network of 1 server and 9 workstations, running SQL Server 6.5 at the back-end and Access 2000 runtime at the front-end, with an ODBC connection.
My problem is that the deletion and addition of rows from/into the SQL Server tables is not working properly as long as there are more than one workstation/user connected. Deleting an order from the Orders table, for example, requires that all other users are logged off.
Why is this and what can I do about it?
Thanks in advance,