Rows created by a stored proc prompt Access' dreaded "write conflict"

Eric E

Hi all,
I am using an Access client linked to a PG 7.4 server via ODBC.

I have a stored proc on the server that inserts rows into a
table.particula r table, accomplished via an INSERT
within the body of the stored proc. The procedure does not explicitly
commit this data, as no transactions are invoked.

The problem is that Access will not modify these records via table or
form view, giving its generic "Write conflict: another user has modified
this record" message. It does just fine for any other records in the
table, but it will not modify those created by the stored proc. It will
also execute an UPDATE OR DELETE query to modify these records This
stored procedure is pretty key for us to go forward.

Does anyone have any ideas of what's going on and how to fix it? I can
post more details, but I wanted to see if this was a known problem
before doing so.

Many thanks,

Eric

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 23 '05 #1

Subscribe Reply

3567

Sim Zacks

After the stored procedure is run, call requery on the form that was
updated.

We are in the middle of moving Access implementations to PostGreSQL.
I'd be happy to trade war stories, if you'd like.

Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

_______________ _______________ _______________ _______________ _______________ _____

Hi all,
I am using an Access client linked to a PG 7.4 server via ODBC.

I have a stored proc on the server that inserts rows into a
table.particula r table, accomplished via an INSERT
within the body of the stored proc. The procedure does not explicitly
commit this data, as no transactions are invoked.

The problem is that Access will not modify these records via table or
form view, giving its generic "Write conflict: another user has modified
this record" message. It does just fine for any other records in the
table, but it will not modify those created by the stored proc. It will
also execute an UPDATE OR DELETE query to modify these records This
stored procedure is pretty key for us to go forward.

Does anyone have any ideas of what's going on and how to fix it? I can
post more details, but I wanted to see if this was a known problem
before doing so.

Many thanks,

Eric

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 23 '05 #2

Sim Zacks

Nov 23 '05 #3

Eric E

Hi Sim,
Thanks for the advice. The problem persists when I close and reopen
any of the objects, or even the database client. I suspect it has
something to do with how Access determines the uniqueID of the row, but
that's only because that seems to be the major issue with Access and
ODBC. Any other suggestions?

Thanks,

Eric

Sim Zacks wrote:

After the stored procedure is run, call requery on the form that was
updated.

We are in the middle of moving Access implementations to PostGreSQL.
I'd be happy to trade war stories, if you'd like.

Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

_______________ _______________ _______________ _______________ _______________ _____

Hi all,
I am using an Access client linked to a PG 7.4 server via ODBC.

I have a stored proc on the server that inserts rows into a
table.particula r table, accomplished via an INSERT
within the body of the stored proc. The procedure does not explicitly
commit this data, as no transactions are invoked.

The problem is that Access will not modify these records via table or
form view, giving its generic "Write conflict: another user has modified
this record" message. It does just fine for any other records in the
table, but it will not modify those created by the stored proc. It will
also execute an UPDATE OR DELETE query to modify these records This
stored procedure is pretty key for us to go forward.

Does anyone have any ideas of what's going on and how to fix it? I can
post more details, but I wanted to see if this was a known problem
before doing so.

Many thanks,

Eric

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #4

Eric E

After the stored procedure is run, call requery on the form that was
updated.

We are in the middle of moving Access implementations to PostGreSQL.
I'd be happy to trade war stories, if you'd like.

Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

_______________ _______________ _______________ _______________ _______________ _____

Hi all,
I am using an Access client linked to a PG 7.4 server via ODBC.

I have a stored proc on the server that inserts rows into a
table.particula r table, accomplished via an INSERT
within the body of the stored proc. The procedure does not explicitly
commit this data, as no transactions are invoked.

The problem is that Access will not modify these records via table or
form view, giving its generic "Write conflict: another user has modified
this record" message. It does just fine for any other records in the
table, but it will not modify those created by the stored proc. It will
also execute an UPDATE OR DELETE query to modify these records This
stored procedure is pretty key for us to go forward.

Does anyone have any ideas of what's going on and how to fix it? I can
post more details, but I wanted to see if this was a known problem
before doing so.

Many thanks,

Eric

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #5

Jeff Eckermann

--- Sim Zacks <si*@compulab.c o.il> wrote:

After the stored procedure is run, call requery on
the form that was
updated.

We are in the middle of moving Access
implementations to PostGreSQL.
I'd be happy to trade war stories, if you'd like.
I hope that you do it on the list, so that the rest of
us can profit from your experience.

Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

_______________ _______________ _______________ _______________ _______________ _____
Hi all,
I am using an Access client linked to a PG 7.4
server via ODBC.

I have a stored proc on the server that inserts rows
into a
table.particula r table, accomplished via an INSERT
within the body of the stored proc. The procedure
does not explicitly
commit this data, as no transactions are invoked.

The problem is that Access will not modify these
records via table or
form view, giving its generic "Write conflict:
another user has modified
this record" message. It does just fine for any
other records in the
table, but it will not modify those created by the
stored proc. It will
also execute an UPDATE OR DELETE query to modify
these records This
stored procedure is pretty key for us to go forward.
Does anyone have any ideas of what's going on and
how to fix it? I can
post more details, but I wanted to see if this was a
known problem
before doing so.

Many thanks,

Eric

---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
ma*******@postg resql.org
---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the
unregister command
(send "unregister YourEmailAddres sHere" to
ma*******@postg resql.org)

_______________ _______________ ____
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 23 '05 #6

Jeff Eckermann

--- Sim Zacks <si*@compulab.c o.il> wrote:

After the stored procedure is run, call requery on
the form that was
updated.

We are in the middle of moving Access
implementations to PostGreSQL.
I'd be happy to trade war stories, if you'd like.
I hope that you do it on the list, so that the rest of
us can profit from your experience.

Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

_______________ _______________ _______________ _______________ _______________ _____
Hi all,
I am using an Access client linked to a PG 7.4
server via ODBC.

I have a stored proc on the server that inserts rows
into a
table.particula r table, accomplished via an INSERT
within the body of the stored proc. The procedure
does not explicitly
commit this data, as no transactions are invoked.

The problem is that Access will not modify these
records via table or
form view, giving its generic "Write conflict:
another user has modified
this record" message. It does just fine for any
other records in the
table, but it will not modify those created by the
stored proc. It will
also execute an UPDATE OR DELETE query to modify
these records This
stored procedure is pretty key for us to go forward.
Does anyone have any ideas of what's going on and
how to fix it? I can
post more details, but I wanted to see if this was a
known problem
before doing so.

Many thanks,

Eric

---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
ma*******@postg resql.org
---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the
unregister command
(send "unregister YourEmailAddres sHere" to
ma*******@postg resql.org)

Nov 23 '05 #7

Sim Zacks

Maybe you need some ODBC settings reconfigured:
Here's what I have, I read a couple of these settings on various lists
and websites and others were the defaults. I would guess if you don't
have row versioning checked, that is the problem.
Also, if you change ODBC settings you have to delete(unlink) the table
and relink it. Just going to Linked Table Manager and refreshing
doesn't do it. Access stores the ODBC settings in each table and does
not really refresh it. So anytime you change the ODBC settings you
have to delete all tables and relink them before it will catch. I
would recommend deleting one table and testing, if possible, and when
you find a setting that works then redo all the tables.
Also I'm using 8.0beta1, so that might also be a difference.

I'm using psqlODBC
Page 1: The only checks I have are Disable Genetic Optimizer, KSQO
and Recognize Unique Indexes. Unknown Sizes is set to Maximum.
Max Varchar and LongVarchar are 4094.
Page 2:
The ones I have checked are LF<>CR?LF conversion, Updateable Cursors
and Row Versioning. (If you don't have row versioning, that might be
the problem, I'm pretty sure it's not a default)
I tested both True is -1 on and off and it didn't make a difference,
now I have it off.
Int8 is Default and I'm not showing OID. Protocol is 7.X,6.4+

Let us know how it goes.

Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

_______________ _______________ _______________ _______________ _______________ _____

Hi Sim,
Thanks for the advice. The problem persists when I close and reopen
any of the objects, or even the database client. I suspect it has
something to do with how Access determines the uniqueID of the row, but
that's only because that seems to be the major issue with Access and
ODBC. Any other suggestions?

Thanks,

Eric

Sim Zacks wrote:

After the stored procedure is run, call requery on the form that was
updated.

We are in the middle of moving Access implementations to PostGreSQL.
I'd be happy to trade war stories, if you'd like.

Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

_______________ _______________ _______________ _______________ _______________ _____

Hi all,
I am using an Access client linked to a PG 7.4 server via ODBC.

I have a stored proc on the server that inserts rows into a
table.particula r table, accomplished via an INSERT
within the body of the stored proc. The procedure does not explicitly
commit this data, as no transactions are invoked.

The problem is that Access will not modify these records via table or
form view, giving its generic "Write conflict: another user has modified
this record" message. It does just fine for any other records in the
table, but it will not modify those created by the stored proc. It will
also execute an UPDATE OR DELETE query to modify these records This
stored procedure is pretty key for us to go forward.

Does anyone have any ideas of what's going on and how to fix it? I can
post more details, but I wanted to see if this was a known problem
before doing so.

Many thanks,

Eric

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #8

Sim Zacks

After the stored procedure is run, call requery on the form that was
updated.

We are in the middle of moving Access implementations to PostGreSQL.
I'd be happy to trade war stories, if you'd like.

Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

_______________ _______________ _______________ _______________ _______________ _____

Hi all,
I am using an Access client linked to a PG 7.4 server via ODBC.

I have a stored proc on the server that inserts rows into a
table.particula r table, accomplished via an INSERT
within the body of the stored proc. The procedure does not explicitly
commit this data, as no transactions are invoked.

The problem is that Access will not modify these records via table or
form view, giving its generic "Write conflict: another user has modified
this record" message. It does just fine for any other records in the
table, but it will not modify those created by the stored proc. It will
also execute an UPDATE OR DELETE query to modify these records This
stored procedure is pretty key for us to go forward.

Does anyone have any ideas of what's going on and how to fix it? I can
post more details, but I wanted to see if this was a known problem
before doing so.

Many thanks,

Eric

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 23 '05 #9

Eric E

Hi Sim,
Got it! Set the Row Versioning Box in Page 2 of the DSN to checked and
the problem no longer occurs. Many thanks for helping me along.

Cheers,

Eric

Sim Zacks wrote:

Maybe you need some ODBC settings reconfigured:
Here's what I have, I read a couple of these settings on various lists
and websites and others were the defaults. I would guess if you don't
have row versioning checked, that is the problem.
Also, if you change ODBC settings you have to delete(unlink) the table
and relink it. Just going to Linked Table Manager and refreshing
doesn't do it. Access stores the ODBC settings in each table and does
not really refresh it. So anytime you change the ODBC settings you
have to delete all tables and relink them before it will catch. I
would recommend deleting one table and testing, if possible, and when
you find a setting that works then redo all the tables.
Also I'm using 8.0beta1, so that might also be a difference.

I'm using psqlODBC
Page 1: The only checks I have are Disable Genetic Optimizer, KSQO
and Recognize Unique Indexes. Unknown Sizes is set to Maximum.
Max Varchar and LongVarchar are 4094.
Page 2:
The ones I have checked are LF<>CR?LF conversion, Updateable Cursors
and Row Versioning. (If you don't have row versioning, that might be
the problem, I'm pretty sure it's not a default)
I tested both True is -1 on and off and it didn't make a difference,
now I have it off.
Int8 is Default and I'm not showing OID. Protocol is 7.X,6.4+

Let us know how it goes.

Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

_______________ _______________ _______________ _______________ _______________ _____

Hi Sim,
Thanks for the advice. The problem persists when I close and reopen
any of the objects, or even the database client. I suspect it has
something to do with how Access determines the uniqueID of the row, but
that's only because that seems to be the major issue with Access and
ODBC. Any other suggestions?

Thanks,

Eric

Sim Zacks wrote:

After the stored procedure is run, call requery on the form that was
updated.

We are in the middle of moving Access implementations to PostGreSQL.
I'd be happy to trade war stories, if you'd like.

Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

_____________ _______________ _______________ _______________ _______________ _______

Hi all,
I am using an Access client linked to a PG 7.4 server via ODBC.

I have a stored proc on the server that inserts rows into a
table.particu lar table, accomplished via an INSERT
within the body of the stored proc. The procedure does not explicitly
commit this data, as no transactions are invoked.

The problem is that Access will not modify these records via table or
form view, giving its generic "Write conflict: another user has modified
this record" message. It does just fine for any other records in the
table, but it will not modify those created by the stored proc. It will
also execute an UPDATE OR DELETE query to modify these records This
stored procedure is pretty key for us to go forward.

Does anyone have any ideas of what's going on and how to fix it? I can
post more details, but I wanted to see if this was a known problem
before doing so.

Many thanks,

Eric

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #10

Similar topics

18909

XSLT: How to write "Yes" if element/attribute exist or "no" if not?

by: Mark Richards | last post by:

The solutions for the following problems seems to be simple but I did not found a (convenient) solution: Assume we have a number of elements of the same type under a common parent e.g. <person ... myattr="aaa">Paul</person> <person ... myattr="bbb">Peter</person> <person ... myattr="ccc">Karl</person> ..... <person ... myattr="ddd">Stan</person>

.NET Framework

5779

Problem with document.write("<td>Hello</td>")

by: bissatch | last post by:

Hi, I am trying to use JavaScript to write a table column on a web page. The code is as follows: <html> <head> <script> function displaycount() {

Javascript

1612

Rows created by a stored proc prompt Access' dreaded "write conflict"

by: Eric E | last post by:

Hi all, I am using an Access 2000 client linked to a Postgresql 7.4 server via ODBC. I have a stored proc on the server that inserts rows into a table.particular table, accomplished via an INSERT within the body of the stored proc. The problem is that Access will not modify these records via table or form view (form has a DAO recordset), giving its generic "Write

Microsoft Access / VBA

2744

how do I "write" an ASP.Net onto the page in code?

by: bennett | last post by:

How can I do a loop from 1 to 5, where on line 1 I print 1 space followed by a button, on line 2 I print 2 spaces followed by a button, on line 3 I print 3 spaces followed by a button, etc.? I tried this code: for (int i = 1; i <= 5 ; ++i) { for (int j = 1; j <= i; ++j) {

ASP.NET

2066

having "throw" write to a file before actually throwing

by: Jacek Dziedzic | last post by:

Hi! <OT, background> I am in a situation where I use two compilers from different vendors to compile my program. It seems that recently, due to a misconfiguration, library conflict or my ignorance, with one of the compilers I am having trouble related to libuwind.so, which, to my knowledge, deals with the intricacies of unwinding the stack upon an exception. Executables compiled with this compiler crash with a SEGV after throw(), never...

C / C++

2993

Write/Redirect output from "Console.out.Write" to panel INSIDE Visual Studio possible ?

by: Steven Prasil | last post by:

When I run/debug a program with Console.out.write statements inside and the program execution reaches this statement then a new console/command prompt window (this with black background) is opened OUTSIDE of VisStudio and the text is written into this new window. I remember that I have seen somewhere a VisStudio session where that text was written instead to a little window panel at the bottom of VisStudio (similar to Errors, Warnings,...

C# / C Sharp

6216

Access Forms "Write Conflict"

by: PRLIT | last post by:

I'm using Access to create forms with a SQLExpress backend. My form is for logging purchases. I have a date ordered and a date delivered. (I know the write issue comes from the date) I've tried adding a TS colum to all of my tables with a timestamp data type (allow nulls). - Still get the error. My recordset type is "updateable snapshot". Not sure what else to try. I've looked at all the others with this issue but have yet to find a...

Microsoft Access / VBA

2026

Books for learning how to write "big" programs

by: duli | last post by:

Hi: I would like recommendations for books (in any language, not necessarily C++, C, python) which have walkthroughs for developing a big software project ? So starting from inception, problem definition, design, coding and final delivery on a single theme or application. Most of the code I have written and books that I have read deal with toy programs and I am looking for something a bit more comprehensive. For example, maybe a...

Python

1726

Re: When do I get "multiple bases have instance lay-out conflict"error?

by: Miles | last post by:

On Mon, Sep 15, 2008 at 6:06 AM, Harish K Vishwanath <harish.shastry@gmail.comwrote: "built-in type" generally means "implemented in C", also sometimes called "extension type". Both the Exception and ZODB Persistent objects are implemented in C, and they have different ideas for the format of the struct that holds an object's data. It can be tricky to tell by introspection whether a

Python

9568

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10156

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10007

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9951

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9832

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8831

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5419

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3531

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2805

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General