Recent content by Zakraket

  1. Z

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

    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.
  2. Z

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

    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
  3. Z

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

    The plot "thickens". When I reconnect the Accessclient to a copy of the database, the problem isn't there. MS Access is still the same build. Reconncting to the "original" database it's back. So now it seems it's something in the database, but it's a 100% copy of the PRD database (although I...
  4. Z

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

    I know it works that way, but I'm only working in the newly created table so far, there are no forms in the picture thusfar (as the screenshots show) Getdate() has worked for me to without issues up untill yesterday, on several databases with different clients in the last 10-12 years....
  5. Z

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

    I've tried ODBC Driver 17 and 18 for SQL server but that doesn't make a difference, the issue also seems to be in every table that has a field that defaults to GetDate() SQL server is 2019 The version of MS Access is 16.0.10406 32bit, and up untill this weekend (serverpark restart by IT due to...
  6. Z

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

    Looking a bit further; I know I never had issues to enter/update records in the table un untill a few weeks. My MSAccess build changed between 10th feb and 12th feb from build 10405 to 10406 and I am very sure that before this week this worked without issues. So, faulty update from MS (again)...
  7. Z

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

    The table in SQL, some records updatebla, some not When I UPDATE the date to not include milliseconds, I can update the other records through MS access This is the other table: no records with milliseconds, except the one I added today But the issue grows now, yet another (existing) table...
  8. Z

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

    I don't have the extended DateTime option (if you refer to the tickbox from your first sceenshot), so that's an issue I could try what happens if I upgrade the GetDate() to enter a less precise date (using some other statement), but it's still a mistery to me why this works without problem in...
  9. Z

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

    Thanks for your input. It's Access version 1808 (9 jan 2024) but I don't have this specific option. But the field is a DateTime as you can see in the script, not datetime2. It's the same as in the other tables where I don't have the issue Another example: I can edit the 3rd and 4th record but...
  10. Z

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

    Now I've narrowed it down to the constraint on the CreatedOn field (getdate()) When I leave the constraint out I do not have this issue. When I recreate the table without this constraint I can update all records. When I then add the constraint on the SQL-server (with an update to the table-def)...
  11. Z

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

    I have a fairly large ERP-system that I'm maintaining for a company. It's a MS Access front end with a SQL database. No issues so far. Now I'm setting up a new table, like I have done numerous times in this system (and others), but now I'm running into this problem: My new table allows...
  12. Z

    setting combo.rowsource fires subform.current() event

    No, because my problem is already solved just by using a parameterquery (based on the SQL view) as the mainform recordsource; with that the subform does not requery anymore when I setv any of the combo's (select * from * where field = forms!form!ID) Your suggestion might solve the problem...
  13. Z

    setting combo.rowsource fires subform.current() event

    I can easily reproduce it now. Did you try my testdb? It's built from scratch so no leftovers from anything and you don't need SQL linked tables, it the same with local Access tables
  14. Z

    setting combo.rowsource fires subform.current() event

    Yes, that seems to make some difference (y) but a subform in a subform just to fix this seems a bit ... awkward, just to fix this At least it (also) works normally when you use a paramquery as recordsource which is a solution for my case It looks to me this is really unintended, unnecessary...
  15. Z

    setting combo.rowsource fires subform.current() event

    not in my testdatabase with the frmInv? Did you set the subform frmInvLines to "select * from tblInvLines" and use the Master/Child InvID on frmInv? (option 1) If I do, I get a msgbox from the subform.current() event after pressing the button that sets the combobox.rowsource When I use option...
Top Bottom