Recent content by Zakraket

@sonic8 I was able to fix my issue by using an updated .dll from the first topic, again thanks for pointing them out

@sonic8 The second thread is exactly the same issue, and it seems someone fixed the library by updating the library to accept the proper type since the thread has been marked resolved. update; I think the solution is in the first thread, I'll look into this, tnx

Hi, thanks for you reply. I'm not familiar with the background of what libraries do like you are, so this is interesting. Siemens has a forum, but it doesn't work properly (for me at least, I see other users posting threads there, but I can't seem to post on the forum (no button that I can...

I need to communicate with a PLC using OPCUA. So I found two libraries for Excel on the Siemens site. OPC_UA_ClientLibrary.dll OPC_UA_ExcelCLient.dll They come with working Excel VBA examples. The first one works, but has limitations; there is no method to read a "struct", that's a PLC node...

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.

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

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

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

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

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)...

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

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

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

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)...

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