Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / November 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eric E - 02 Nov 2004 02:42 GMT
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
conflict: another user has modified this record" message.  I can use
forms and table view 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 kind of
stored procedure is pretty key for us going 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
Eric E - 02 Nov 2004 17:32 GMT
I resolved this problem: it turned out that the PGSQL ODBC driver needed
to have "Row Versioning" checked.

Cheers,

Eric

> Hi all,
>    I am using an Access 2000 client linked to a Postgresql 7.4 server
[quoted text clipped - 19 lines]
>
> Eric
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.