X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Odbc Table Records Not Editable, Access 2016    
post Jun 11 2018, 10:37 AM

Posts: 110
Joined: 25-June 16

I can enter new records fine on this table, but immediately after they are locked (Write Conflict).
There is nobody else in these as this DB is still on a test account.
If I export the data, delete it all, and import again I can edit those records again, but once I create a new one and go back to it that new one is locked again. The old ones I can edit over and over no problem.

It is assigning the Primary Key just fine on these.
Go to the top of the page
John Vinson
post Jun 12 2018, 11:58 AM

UtterAccess VIP
Posts: 4,270
Joined: 6-January 07
From: Parma, Idaho, US

Need a bit more info to help on this!

You say ODBC - where is the table actually located? What kind of database - SQL/Server, another Access database, something else? Is it editable from some other app? Is there any VBA code, Data Macro or host-database trigger which might be interfering?
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    22nd October 2018 - 09:28 AM