Deleting/appending rows in SQL 6.5

Deleting/appending rows in SQL 6.5

Post by Mathias Engstr? » Sat, 29 Jan 2000 04:00:00

Hello newsgroup,

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,

Mathias Engstr?m
Helsinki, Finland


Deleting/appending rows in SQL 6.5

Post by Bob Pfeif » Sat, 29 Jan 2000 04:00:00

What kind of message do you get when someone tries to delete when other users are in the system?  You could run sp_who2 and sp_lock to see what kind of locking and possible blocking is going on.


1. Solution for #DELETED rows with Access as SQL Server 6.5


As you know there is a lot of pleople posting mesages that the combination
of  Access 2.0-97 and SQL Server 6.5 gives #DELETED rows on SQL server
attached tables.

This is a know problem with Access 2-Access 97 and SQL 6.5. As you know SQL
6.5 ODBC
driver use the New ANSI nulls behavior. Jet does not like it at all.

You MUST use SQL Server 6.5 SP2 ODBC driver. This driver has the avility to
disable the new ANSI Nulls behavior.

Also note that you must use the new driver from SP2 (2.65.240) for Upsizing
a table to SQL..

Hope this help


2. Normalization question - bill to invoice relationship

3. Problem with deleting rows in SQLS 6.5


5. MS SQL Server 6.5/PowerDesignor 6.0 Trigger Templates: Cycling Row by Row

6. Any DB FAQ or DB Reviews?

7. Append to linked SQL 6.5 tables

8. Long appending time on SQL 6.5 + VC 6

9. SQL Server 6.5 append performance problem

10. SQL Server 6.5 disk dumps append??

11. Append Query from Access 97 to SQL 6.5 SP3

12. Long appending time on SQL 6.5 + VC 6