SQL table linked in MSAccess, insert yes, update/delete no

[Zakraket]

That's it! I changed the compatilitylevel of the database because I needed to use some function (can't remember what), but I changed the server to 150 (2019). I overwrote the database and ran all updates (including the compatibility level) but on the "new" database the issue doesn't yet exist

 

[Minty]

I only thought about it afterwards, but should have mentioned it right at the start.

We created a new database for a client and imported everything from a working copy, and we couldn't get the front end to connect to it.
We ended up having to go to a new SQL driver for them (No bad thing tbh) then it connected fine.

After a lot of digging we found the only difference - the compatibility level!

Glad it helped.

 

[Zakraket]

I haven't tested (yet), but it must be this, tnx!

A new driver is an option, but it would require testing of the whole system, no time for that a.t.m.