Board index MS SQL Server

Can't update records I've created

Can't update records I've created

Post by Roger Carlso » Sun, 19 Aug 2001 03:31:26



Ok, here's a strange one.  SQL Server 2000 Back End,
Access 97 FE, Linked tables with ODBC connection.  I can
edit records in the Customer Table.  I can create a new
record in the Customer Table.  However, if I try to edit
the record that I created in the Customer Table, I get a
Write Conflict error.  I am the only user at present.  I
have tried closing the application and re-opening it and
it is still locked.  I have re-booted my workstation and
it is still locked.  However, records that were imported
from the original Access Back End (using DTS) can be
edited and re-edited.  Oh, but I can go to Enterprise
Manager in SQL2000 and change or delete the offending
records there.

I can add records and make changes to records in *other*
tables in the database, just not the Customer table.

Does this sound like anything that anyone has seen?  Any
idea where I should start looking?

-- Roger Carlson
   Sr. Programmer/Analyst
   Spectrum Health I&TM
   http://www.rogersaccesslibrary.com

 
 
 
Top

Can't update records I've created

Post by Roger Carlso » Sun, 19 Aug 2001 03:58:15


Well, I found the answer myself in the Knowledgebase:

Q278696 - ACC97: Write Conflict Error When You Try to
Update Records in a Linked SQL Server Table

Thought I might as well post the answer in case others are
interested.

--Roger

Quote:>-----Original Message-----
>Ok, here's a strange one.  SQL Server 2000 Back End,
>Access 97 FE, Linked tables with ODBC connection.  I can
>edit records in the Customer Table.  I can create a new
>record in the Customer Table.  However, if I try to edit
>the record that I created in the Customer Table, I get a
>Write Conflict error.  I am the only user at present.  I
>have tried closing the application and re-opening it and
>it is still locked.  I have re-booted my workstation and
>it is still locked.  However, records that were imported
>from the original Access Back End (using DTS) can be
>edited and re-edited.  Oh, but I can go to Enterprise
>Manager in SQL2000 and change or delete the offending
>records there.

>I can add records and make changes to records in *other*
>tables in the database, just not the Customer table.

>Does this sound like anything that anyone has seen?  Any
>idea where I should start looking?

>-- Roger Carlson
>   Sr. Programmer/Analyst
>   Spectrum Health I&TM
>   http://www.rogersaccesslibrary.com
>.


 
 
 
Top

Can't update records I've created

Post by Russell Scher » Thu, 23 Aug 2001 04:23:25


Hello Roger,

Can you please provide for me the exact error message that you receive? Can
you also provide the exact table structure of the Customer table (i.e.,
script the Customer table)?

In the meantime, I would recommend that you start a SQL Server profiler
trace while you try and modify the linked table from Access 97 to see what
underlying SQL Server statements are being executed (or not being
executed). Please see SQL Server 2000 Books Online for details ("How to
create a trace (SQL Server Profiler)" is a good starting point).

Regards,
Russ

 
 
 
Top

1. Record Set Guru's - Can't Create Record Set error 429

Hi All,

(Excuse me if this is a repost because I had trouble with my news reader.)

I have tried and tried to figure this one out and I am stuck.  I have an
COMponent created with VB5 that runs under MTS and is accessed via VBScript
ASP pages.  For some strange reason when my VB5 object tries to set a
property of the record set it created I get:
"Error  429 , ActiveX component can't create object"  This same method
worked previously.  I have tried everything, even reinstalled OLEDB SDK.
Code snippets follow:
On Error GoTo ErrorHandler
Dim oConnection     As New ADODB.Connection
Dim oCommand        As New ADODB.Command
Dim oRecordSet      As New ADODB.Recordset

'Open the connection to the data source
oConnection.Open sDSN, sUID, sPSW
Set oCommand.ActiveConnection = oConnection
'Set up parameters
oCommand.CommandText = "sp_SomeSP"
oCommand.CommandType = adCmdStoredProc
oCommand.CommandTimeout = 20
oCommand.Parameters(1) = "some parameter value"
'Here is where I get the error!
oRecordSet.CursorLocation = adUseClientBatch
oRecordSet.Open oCommand, , adOpenUnspecified, adLockBatchOptimistic

'Clean up
Set oConnection = Nothing
Set oCommand = Nothing
Any Help would be greatly appreciated!!!!!
Mike Alvarez
POV Partners

To reply via email remove the anit-spam part address

remove the anit-spam part address

2. 1/2" tape on NT? (for mvBase)

3. I've read the FAQ regarding printing the currrent record from a form....but

4. Repeaters

5. I've just replaced the last dBA and don't know the sa password

6. Problem with connection to Informix 7.21(BDE 4.0), HELP

7. SQLMail - I've read the KB but I'm still stuck

8. To-Date Calculations

9. Security - I'm as confused as I've ever been

10. memo files--i've crashed and i can't boot up

11. I've got a small problem with Unify's SQL

12. WinVFP3: Help, I've list my toolbars and can't find them


All times are UTC
Board index