UtterAccess.com
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    
 
   
arpirnat
post Jun 11 2018, 10:37 AM
Post#1



Posts: 107
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
Post#2


UtterAccess VIP
Posts: 4,235
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?

--------------------
John W. Vinson
Wysard of Information
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    24th June 2018 - 11:37 AM